i want to give more than 6 condition by using if statement

[Sushil]

when i am given the below condition it is given me an error, please help me
how to do it for the students details.

=IF(C4<35,"Fail",IF(D4<35,"Fail",IF(E4<35,"Fail",IF(F4<35,"Fail",IF(G4<35,"Fail",IF(H4<35,"Fail",if(j4<45,"Pass",if(j4<60,"Second
Class",if(j4<75,"First Class","Distinction")))))))))

[Ron Rosenfeld]

On Sat, 14 May 2005 10:16:04 -0700, Sushil <[email protected]>
wrote:

>when i am given the below condition it is given me an error, please help me
>how to do it for the students details.
>
>=IF(C4<35,"Fail",IF(D4<35,"Fail",IF(E4<35,"Fail",IF(F4<35,"Fail",IF(G4<35,"Fail",IF(H4<35,"Fail",if(j4<45,"Pass",if(j4<60,"Second
>Class",if(j4<75,"First Class","Distinction")))))))))

A different approach, using VLOOKUP, would work better.

If I understand your formula, you are computing:

1. If any cell in the range C4:H4 is < 35, then "Fail".
2. Otherwise, compute a response based on the contents of J4.

That being the case, the following formula will accomplish that:

=IF(COUNTIF(C4:H4,"<35"),"Fail",VLOOKUP(J4,
{35,"Pass";45,"Second Class";60,"First Class";75,"Distinction"},2))

The array constant can also be placed in a two column vertical table, and
referred to by a Name or Cell Reference (e.g. X1:Y4):

35 Pass
45 Second Class
60 First Class
75 Distinction



--ron

[Eric Borsheim]

I think you have exceeded the IF statement speed limit! Strictly as
a footnote, there is a limited number of IF statements that you can
string together and when you exceed that limit (which is nowhere near
your logic limit), they just don't work. A working knowledge of logic
statements can accomplish some amazing tasks; Ron reminds us, however,
that there are much more elegant solutions.