Excel Formula
This query is : Resolved
10 July 2010
Sir
Please tell me the formula of Excel to round off many figures to nearest 100 or 1000 simultaneously
Please tell me the formula of Excel to round off many figures to nearest 100 or 1000 simultaneously
10 July 2010
=ROUNDUP(NumberToRound,DecimalPlacesToUse)--Rounds a number up, away from zero
=ROUNDDOWN(NumberToRound,DecimalPlacesToUse)--Rounds a number down, toward zero
=ROUND(NumberToRound,DecimalPlacesToUse)--Rounds a number to a specified number of digits
=ROUNDDOWN(NumberToRound,DecimalPlacesToUse)--Rounds a number down, toward zero
=ROUND(NumberToRound,DecimalPlacesToUse)--Rounds a number to a specified number of digits
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- GST Regis.
- Should I include march foreign salary received in April in my income for FY 2023-24?
- Tax on capital gains revoked us 54f
- Inventory of finished goods
- HSN Details in IFF/GSTR-1 & in GSTR 9
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- Sale of property furniture sale
- Filing of Form 10BB instead of Filing Form 10B
- Applicability of Ind As to associate of associate
- GST Registration Cancellation books of accounts asked by officer
- TDS Deduction Online Learing Platform
- Point (III) 9 of GSTR-9C
- As per our records, find the below outstanding demand(s)* and interest payable u/s 220(2):
- Regarding transaction th. credit card
- MIS MATCH OF INVOICE NUMBER
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
Trending Online Classes
CAclubindia
