| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF condition Nesting limit error
Hello:
Here is an alternative to the lookup function: =CHOOSE((AA1029)+(AA1034)+(AA1039)+(AA1044)+(A A1049)+(AA1054)+ (AA1059)+(AA1064)+(AA10=69)+(AA10=74)+(AA1079 )+(AA1089)+1, "F","E","D-","D","C-","C","C+","B-","B","B+","A-","A","A+") BTW, What happen to D+? Pieter Vandenberg PKadam wrote: : Hi All, : I am trying to use the formula to calculate the grades, but i am getting an : error for exceeding the Nested limits. : My formula looks like this : =IF(AA1089,"A+", IF(AA1079,"A", IF(AA1074,"A-", IF(AA1069,"B+", : IF(AA1064,"B", IF(AA1059,"B-", IF(AA1054,"C+", IF(AA1049,"C", : IF(AA1044,"C-", IF(AA1039,"D", IF(AA1034,"D-", IF(AA1029,"E",F)))))))))))) : Any suggestions ? : Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL - Oracle connection Error | Excel Discussion (Misc queries) | |||
| Have I exceeded nesting limit | Excel Worksheet Functions | |||
| ERROR | Excel Discussion (Misc queries) | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
| Findlink Error | Links and Linking in Excel | |||
Threaded Mode
