K
Khaled
How can I round 980 to 1,000?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
With 980 in A1, you can use this:
=ROUNDUP(A1,-3)
Hope this helps.
Pete
=ROUNDUP(A1,-3)
Hope this helps.
Pete
K
Khaled
It did help, thanks Pete.
With 980 in A1, you can use this:
=ROUNDUP(A1,-3)
Hope this helps.
Pete
- Show quoted text -
A
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
You may also try =mround(A3,100). For Excel 2003 and prior versions, you
would have to install the Analysis Toolpak from Tools > Addins
D
David Biddulph
=ROUND(A3,-2) will do, and that doesn't need ATP.
A
Ashish Mathur
Hi,
I know that. I was just giving an alternative
I know that. I was just giving an alternative