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 |
process order with IF statement
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. -- David Biddulph rebecca wrote: 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 |
All times are GMT +1. The time now is 04:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com