Special Rounding formula help

[Yeti_5]

Hello,
I have spreadsheet that has 18 columns containing numbers ranging from 0 to 99,999.99, and I need to round each of these numbers.
What I need to do is as follows:
If #<100 - Then round to nearest Tens place (i.e. 64 would become 60)
If #>100 - Then round to the nearest Hundreds pace (i.e. 348 would become 300)

I know how to create a basic ROUND formula to follow ONE of these rules, however, I need a formula that will follow either rule based on the number.

Is there a certain "IF" formula that would allow me to tackle this?

Any help is greatly appreciated.

Thank you all!!!

 

[AliGW]

Try this:

=IF(B1<100,MROUND(B1,10),MROUND(B1,100))

 

[Yeti_5]

Try this:

=IF(B1<100,MROUND(B1,10),MROUND(B1,100))

PERFECT!
Thanks!

 

[AliGW]

You're welcome!