Excel Formula

This query is : Resolved

Report Abuse Follow Query Ask a Query

RAKHI CHAUDHARY

RAKHI CHAUDHARY (Querist)
Follow

10 July 2010 Sir
Please tell me the formula of Excel to round off many figures to nearest 100 or 1000 simultaneously

KARAN SHARMA

KARAN SHARMA (Expert)
Follow

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