| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
How do I enter a formula to look at a number and based on calculation round
up or down to nearest hundreth? For example 421 would round down to 400 while 573 would round up to 600. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
try =round(a1,-2) where A1 has the number you want to round to the 100's
"Jackie Morin" wrote: How do I enter a formula to look at a number and based on calculation round up or down to nearest hundreth? For example 421 would round down to 400 while 573 would round up to 600. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
You could look up ROUND in Excel help.
Try =ROUND(A2,-2) -- David Biddulph Jackie Morin wrote: How do I enter a formula to look at a number and based on calculation round up or down to nearest hundreth? For example 421 would round down to 400 while 573 would round up to 600. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
