Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rashid Hussain Rashid Hussain is offline
external usenet poster
 
Posts: 1
Default 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.