IF condition problem

[Muthukrishnan V]

Microsoft Excel 2007

Column P52 contains this formula:
=IF(C52>10,IF(E52>15,IF(G52>20,IF(I52>50,IF(K52>100,"Pass","Fail")),"Fail")))
Columns C, E, G, I, K contain marks in numerical.
My problem: If I52 is less than 50 result in P52 should show "Fail". Instead it shows "FALSE".
If I52 is more than 50 result in P52 shows correctly "Pass".
Results are OK with the marks in Columns C, E, G and K.
Column I only gives problem
Kindly give me a solution. Thanks,

 

[kweaver]

Could you provide a few alternatives for C E G I and K?

If I52 is less than 50, what do you want in P52?

Maybe you want this?

=IF(C52>10,IF(E52>15,IF(G52>20,IF(AND(I52>50,K52>100),"Pass","Fail")),"Fail"))

 

[Michael M]

Maybe this

=IF(OR(C52>10,E52>15,G52>20,I52>50,K52>100),"Pass","Fail")

 

[Muthukrishnan V]

Could you provide a few alternatives for C E G I and K?

If I52 is less than 50, what do you want in P52?

Maybe you want this?

=IF(C52>10,IF(E52>15,IF(G52>20,IF(AND(I52>50,K52>100),"Pass","Fail")),"Fail"))

If I52 is less than 50, P52 should show "Fail". (Not "False")

Te above code says "too many arguments"

 

[Muthukrishnan V]

Maybe this

=IF(OR(C52>10,E52>15,G52>20,I52>50,K52>100),"Pass","Fail")

Even if I 52 is <50, shows "Pass" (should be "Fail")

 

[kweaver]

 

[Michael M]

what if one of the other conditions have been met.....I52 might be less than 50, but if C, E,G or K are true then it will give pass !

 

[Muthukrishnan V]

Sir, In the above example, kindly alter C52 input as 5. (If C52<10 Fail). Now P52 shows FALSE.
C52 fail marks and also I52 fail marks. Correct answer is FAIL. All conditions fromC52,E52,G52,I52 and K52 decide pass or fail.
Thanks. Request solution.

 

[Muthukrishnan V]

I reframe my problem:
Mark1 Mark2 Mark3 Mark Mark5 Result
Pass>10 Pass>15 Pass>20 Pass>50 Pass>100
20 30 40 100 200 Pass Pass in all subjects
1 2 3 4 5 Fail Fail because A5:E5 all fail
11 12 15 55 39 Fail Fail because B6,C6 and E6
11 22 33 45 180 Fail Fail because D7
Even in ONE subject Fail, result will be Fail.
Only if pass in all 5 subjects,result will be Pass
To achieve this formula required in Column F4 to F7.

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F
1	Mark1	Mark2	Mark3	Mark4	Mark5	Result
2	Pass>10	Pass>15	Pass>20	Pass>50	Pass>100
3	20	30	40	100	200	Pass
4	1	2	3	4	5	Fail
5	11	12	15	55	39	Fail
6	11	22	33	45	180	Fail
Sheet2

Cell Formulas
Range	Formula
F3	=IF(AND(A3>10,B3>15,C3>20,D3>50,E3>100),"Pass","Fail")