| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I round a number to the nearest 900?
a number between XXXX900 to XXXY350 gets rounded to the lower number and
XXXY351 to XXXY900 gets rounded to upper number =IF(MOD(A1,1000)<=350,1000*(INT(A1/1000)-1)+900,1000*(INT(A1/1000))+900) "trainer07" wrote: what we are looking for is to round to the nearest 900. Example: if you have $100,500 we want it rounded to $100,900. If we have $100,200 we want it rounded to $99,900. Any help would be appreciated. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round a number to the Nearest .25 | Excel Worksheet Functions | |||
| Is there a formula to round a number to the nearest .09? | Excel Worksheet Functions | |||
| How do I round a 4 digits number to it's nearest 10 | Excel Worksheet Functions | |||
| want to round a number to the nearest quarter 0.25-0.50-0.45-0.00 | Excel Worksheet Functions | |||
| How can I round a number to the nearest "50" or "100" in excel 200 | Excel Worksheet Functions | |||
Hybrid Mode
