Formula Rounding a number when subject number is less than, between, greater than

[HunterLynn]

I am looking to create a formula that will do the following:

Round a number (qty) to a particular decimal if the number (qty) falls into the following criteria, less than $10 per unit (rounded to 1.0), between $10-$100 per unit (rounded to 0.1), over $100 per unit (rounded to 0.01).

Ex:

15.4 qty $13.09 per unit

15.4 would be rounded to 15 because the per unit cost is $13.09.

I can create a formula for the rounding, a formula for a less than or greater than, but not the between and I don't know how to combine the two requests.

Thanks for any help.

 

[shg]

between $10-$100 per unit (rounded to 0.1),

Wouldn't 15.4 remain as is, because 13.09 is between 10 and 100?

 

[mancemonster]

Something like???

=IF(A1<10,ROUND(B1,0),IF(AND(A1>=10,A1<100),ROUND(B1,1),IF(A1>=100,ROUND(B1,2))))

 

[HunterLynn]

Thanks Mancemonster... with one small tweek (just to suit my numbers) all is well in the rounding household! Thank you Thank you Thank you! I LOVE THIS PLACE!