| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Something is wrong with this IF statment
if(AS31100,73,if(as31000,77,if(as3900,82,if(as3 800,82,if(as3700,84,if(as3600,77,if(as3500,80, if(as3400,85.1,if(as3300,83.4,if(as3200,89.8,if (as3100,103,if(as30,103,0))))))))))))
Does Office cutout after too many nested if? when i click ok on the error it higlights my 6th last if. If i delete all ifs after and make the 6th last the last if, it works fine... it also doesn't highlight my as3 reference after the 6th last if... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ###### Wrong Formula | Excel Discussion (Misc queries) | |||
| How do I recover data that somebody pasted over on the wrong page | Excel Discussion (Misc queries) | |||
| SUMPRODUCT is showing wrong Amount | Excel Discussion (Misc queries) | |||
| hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
| wrong year | Excel Worksheet Functions | |||
Threaded Mode
