Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I don't know which funaction is the right and how it's process | Excel Discussion (Misc queries) | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
need to automate process | Excel Discussion (Misc queries) | |||
If/then Process? | Excel Discussion (Misc queries) | |||
Iterative process, | Excel Discussion (Misc queries) |