| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula not working
The following works:
=IF(AND(B22=150,B22<=159),18.5,IF(AND(B22=160,B2 2<=169),15.9,IF(AND(B22=1 70,B22<=179),13.8,IF(AND(B22=180,B22<=189),12.5,I F(AND(B22=190,B22<=199),1 0.7,IF(AND(B22=200,B22<=209),9.6,IF(AND(B22=210, B22<=219),9.2)))))))/2 However, the below does NOT =IF(ISNUMBER(B2),IF(AND(B22=150,B22<=159),18.5,IF (AND(B22=160,B22<=169),15 ..9,IF(AND(B22=170,B22<=179),13.8,IF(AND(B22=180 ,B22<=189),12.5,IF(AND(B22 =190,B22<=199),10.7,IF(AND(B22=200,B22<=209),9.6, IF(AND(B22=210,B22<=219), 9.2)))))))/2,"") By adding the ISNUMBER and first IF, casuses the formula to not work... Is it the length of the formula? Carl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Excel: Formula worked last week but now stoppped working. | Excel Worksheet Functions | |||
| Excel formula not working | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
