Problem in "if" formulla

  • Thread starter Thread starter syeed Hassan
  • Start date Start date
S

syeed Hassan

when i need to put more than 8(eight) logic, the excel
gives an error message. So, how i can use more than 8
logic in if formulla.

Like,
=if(a1>=97,"A+",if(a1>=90,"A",if(a1>=87,"A-",if
(a1>=85,"B+",if(a1>=80,"B",if(a1>=77,"B-",if(a1>=75,"C+",if
(a1>=70,"C",if(a1>=67,"c-",if(a1>=60,"D",if
(a1<60,"F")))))))))))

So, please, let me know how i can get solution?
 
syeed Hassan said:
when i need to put more than 8(eight) logic, the excel
gives an error message. So, how i can use more than 8
logic in if formulla.

Like,
=if(a1>=97,"A+",if(a1>=90,"A",if(a1>=87,"A-",if
(a1>=85,"B+",if(a1>=80,"B",if(a1>=77,"B-",if(a1>=75,"C+",if
(a1>=70,"C",if(a1>=67,"c-",if(a1>=60,"D",if
(a1<60,"F")))))))))))

So, please, let me know how i can get solution?
Click to expand...

It looks like you are doing a marksheet!

7 nested If's is the maximum allowed so if you need more you could do it in
2 or more hidden cells with a third (unhidden one) displaying the result of
where there is a value in the hidden ones.

Peter
 
Use VLOOKUP.

In Column A put the grades as per your IF statement (i.e.
97, 90, 87, etc.) in column B, the associated grade. Then
in the cell you require the answer e.g. G1, =VLOOKUP
(G1,A1:B8,2)

Hope it helps.

TGB
 
A B C D E
1 68 C- 0 F
2 60 D
3 67 C-
4 70 C
5 75 C+
6 77 B-
7 80 B
8 85 B+
9 87 A-
10 90 A
11 97 A+

B1: =VLOOKUP(A1,D1:E11,2)
 
Change if(a1>=60,"D" to if(a1>>=60,"D","F". Delete last
logic statement. By default anything under 60 is an "F".
 
-----Original Message-----
when i need to put more than 8(eight) logic, the excel
gives an error message. So, how i can use more than 8
logic in if formulla.

Like,
=if(a1>=97,"A+",if(a1>=90,"A",if(a1>=87,"A-",if
(a1>=85,"B+",if(a1>=80,"B",if(a1>=77,"B-",if (a1>=75,"C+",if
(a1>=70,"C",if(a1>=67,"c-",if(a1>=60,"D",if
(a1<60,"F")))))))))))

So, please, let me know how i can get solution for this type of problem?
Please give me the solution about the problem that i am facing. I need your help.
Click to expand...
 
Back
Top