process order with IF statement

[rebecca]

I'm using the following to round to the nearest quarter UNLESS the
number is under 0.25, then it should display the actual number:

=IF((B49/173)< 0.25,ROUND((B49/173)/0.25,0)*0.25,B49/173)

If I substitute a simpler condition, the logic works. I'm thinking
this is a mathmatical order of events problem --

Any solutions????

Thanks

 

[David Biddulph]

I think your formula is doing the opposite of what you described.

=IF(B49/173< 0.25,B49/173,ROUND((B49/173)/0.25,0)*0.25)
or
=IF(B49/173< 0.25,B49/173,MROUND(B49/173,0.25))

If you have trouble with MROUND, look it up in Excel help.