| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Function Help due to 7 limit
Using Excel 2003
Using the following formula It works great Except that when the input cell is blank ( or "deleted"), a Zero is entered in cell "W?" This in turn causes the formula to return a 30, NOT the Zero that I'm Looking for. Can the formula be reworked? or somehow multiple nested? (the input/supply cell is restricted to minimum of 24 and maximum of 72, so that part is looked after) =IF(W58=24,24,IF(W58<=30,30,IF(W58<=36,36,IF(W58<= 42,42,IF(W58<=48,48,IF(W58<=54,54,IF(W58<=60,60,IF (W58<=66,66,72)))))))) Thanks -- John F. Scholten |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Threaded Mode
