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