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.

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.

=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.

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.

=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.
.

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.
.