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.

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.

--
Regards

Roger Govier


"Rashid Hussain" <Rashid wrote in
message ...
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.

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:

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.