Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I round DOWN only, 24999 to 24000.
In my business, we have to round numbers DOWN, not to the closest 1000, for
values over 50,000. From 20-50,000, we have to round DOWN to the 500. Under 20000, we have to round DOWN to 100. I can't figure it out. |
#2
|
|||
|
|||
One way
=IF(C2=20000,FLOOR(C2,500),FLOOR(C2,100)) -- Regards, Peo Sjoblom "Ian" wrote in message ... In my business, we have to round numbers DOWN, not to the closest 1000, for values over 50,000. From 20-50,000, we have to round DOWN to the 500. Under 20000, we have to round DOWN to 100. I can't figure it out. |
#3
|
|||
|
|||
=if(A1<20000,FLOOR(A1,100),IF(A1<=50000,FLOOR(A1,5 00),FLOOR(A1,1000)))
-- HTH RP (remove nothere from the email address if mailing direct) "Ian" wrote in message ... In my business, we have to round numbers DOWN, not to the closest 1000, for values over 50,000. From 20-50,000, we have to round DOWN to the 500. Under 20000, we have to round DOWN to 100. I can't figure it out. |
#4
|
|||
|
|||
Hi Ian
One way would be if A1 conyains your original value =IF(A150000,ROUNDDOWN(A1,-3),IF(A125000,(ROUNDDOWN(A1/5,-2))*5,ROUNDDOWN(A1,-2))) -- Regards Roger Govier "Ian" wrote in message ... In my business, we have to round numbers DOWN, not to the closest 1000, for values over 50,000. From 20-50,000, we have to round DOWN to the 500. Under 20000, we have to round DOWN to 100. I can't figure it out. |
#5
|
|||
|
|||
=FLOOR(A1,LOOKUP(A1,{0,20000,50000},{100,500,1000} ))
HTH Jason Atlanta, GA -----Original Message----- In my business, we have to round numbers DOWN, not to the closest 1000, for values over 50,000. From 20-50,000, we have to round DOWN to the 500. Under 20000, we have to round DOWN to 100. I can't figure it out. . |
#6
|
|||
|
|||
Hi Jason
Very neat! -- Regards Roger Govier "Jason Morin" wrote in message ... =FLOOR(A1,LOOKUP(A1,{0,20000,50000},{100,500,1000} )) HTH Jason Atlanta, GA -----Original Message----- In my business, we have to round numbers DOWN, not to the closest 1000, for values over 50,000. From 20-50,000, we have to round DOWN to the 500. Under 20000, we have to round DOWN to 100. I can't figure it out. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions | |||
Round Up Time IF | Excel Worksheet Functions | |||
How can i round off .10 as .50 and .51 as 1.00 | Excel Worksheet Functions | |||
Round Time | Excel Worksheet Functions |