formula

[Rashid Hussain]

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(GW6>84,"A+",IF(GW6>79,"A",IF(GW6>74,"B+",IF(GW6>69,"B",IF(GW6>64,"B-",IF(GW6>59,"C+",IF(GW6>54,"C",IF(GW6>49,"D","F"))))))))

=IF(GW6>84,"A+",IF(GW6>79,"A",IF(GW6>74,"B+",IF(GW6>69,"B",IF(GW6>64,"B-",IF(GW6>59,"C+",IF(GW6>54,"C",IF(GW6>49,"C-",IF(GW6>44,"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.

 

[Roger Govier]

Hi Rashid

You would be much better off with a lookup table.
In cells A1:A10 enter the numbers 0,44,49 .... to 84
In cells B1:B10 enter F,D,C-,.........to A

Assuming the mark was in C1 then the formula would be
=VLOOKUP(C1,$A$1:$B$10,2)

Change the location of your table to suit your requirements and amend
the formula accordingly.

 

[Stefi]

Try this:
=VLOOKUP(GW6,{0,"F";45,"D";50,"C-";55,"C";60,"C+";65,"B-";70,"B";75,"B+";80,"A";85,"A+"},2)

Regards,
Stefi

„Rashid Hussain†ezt írta: