| 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 |
| 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) | |||
Threaded Mode
