Round formula

[Khaled]

How can I round 980 to 1,000?

 

[Pete_UK]

With 980 in A1, you can use this:

=ROUNDUP(A1,-3)

Hope this helps.

Pete

 

[Khaled]

It did help, thanks Pete.

With 980 in A1, you can use this:

=ROUNDUP(A1,-3)

Hope this helps.

Pete



- Show quoted text -

 

[Ashish Mathur]

Hi,

You may also try =mround(A3,100). For Excel 2003 and prior versions, you
would have to install the Analysis Toolpak from Tools > Addins

 

[David Biddulph]

=ROUND(A3,-2) will do, and that doesn't need ATP.

 

[Ashish Mathur]

Hi,

I know that. I was just giving an alternative