How do I round a number to the nearest 900?

T

trainer07

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!
 
J

Joel

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can you round a number to the nearest 900? 17
How can you round a number to the nearest 900? 3
Round time to nearest 15 minutes in decimal format 4
How can I Round up to the nearest .25 11
how to multiply two values and round the result 5
How do I round a number to the nearest thousand in Excel??? 3
How to use Ceiling to round? 11
ROUNDING UP TO NEAREST 9 4

Top