View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rebecca rebecca is offline
external usenet poster
 
Posts: 4
Default process order with IF statement

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