formula
i have to prepare result of my department on Excel. But excel does not aceed
more than 8 conditons if i am going to apply 9 or 10 conditions for solving
the problem i am pasting the either farmula below:
=IF(GW684,"A+",IF(GW679,"A",IF(GW674,"B+",IF(GW 669,"B",IF(GW664,"B-",IF(GW659,"C+",IF(GW654,"C",IF(GW649,"D","F")) ))))))
=IF(GW684,"A+",IF(GW679,"A",IF(GW674,"B+",IF(GW 669,"B",IF(GW664,"B-",IF(GW659,"C+",IF(GW654,"C",IF(GW649,"C-",IF(GW644,"D","F")))))))))
the former is correct one whereas the later one is also logically corrent
but excel does not accept, like as i add C- with logical condition but it
does accpet, please help me out.
|