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.