Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
overcome from the restriction of number of IF statements
Hi all,
I have two formulas in two adjacent cells. One beeing: =IF(AND(AA289;AA2<101);"AA";IF(AND(AA284;AA2<90) ;"BA";IF(AND(AA279;AA2<85);"BB";IF(AND(AA274;AA2 <80);"CB";"-")))) and the other =IF(AND(AA269;AA2<75);"CC";IF(AND(AA264;AA2<70); "DC";IF(AND(AA259;AA2<65);"DD";IF(AND(AA249;AA2< 60);"FD";IF(AND(AA20;AA2<50);"FF";"-"))))) I was intending two use one single cell for the purpose but failed because of the restriction of the number of IF conditions within a single cell. Is there a cure for this problem?. Can I combine the two cell conditions into one cell with a combined formula? Thanks J_J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overcome LOOKUP limits and NOW() | Excel Worksheet Functions | |||
How to overcome LOOKUP function problems? | Excel Worksheet Functions | |||
how do I overcome this combobox 'bug'? | Excel Programming | |||
Pivot Table - Overcome col. limit? | Excel Programming |