Re: Excel Gurus Help: Nested IF
^ how do I use the OR?
this is the If function I was trying to use before I discovered that you can not nest more than 7 IF functions.
=IF(P3<11,"U",IF(P3<14,"G-",IF(P3<17,"G",IF(P3<21,"G+",IF(P3<24,"F-",IF(P3<27,"F",IF(P3<31,"F+",IF(P3<34,"E",IF(P3<37,"E",IF(P3<41,"E+",IF(P3<44,“D-",IF(P3<47,"D",IF(P3<51,“D+",IF(P3<54,"C",IF(P3<57,"C",IF(P3<61,"C+",IF(P3<64,"B-",IF(P3<67,"B",IF(P3<71,"B+",IF(P3<74,"A-",IF(P3<77,"A",”A+”)))))))))))))))))))))
