IF condition problem

Muthukrishnan V

Active Member
Joined
May 29, 2008
Messages
297
Office Version
  1. 365
Platform
  1. Windows
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,
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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?

Rich (BB code):
=IF(C52>10,IF(E52>15,IF(G52>20,IF(AND(I52>50,K52>100),"Pass","Fail")),"Fail"))
 
Last edited:
Upvote 0
Maybe this

Code:
=IF(OR(C52>10,E52>15,G52>20,I52>50,K52>100),"Pass","Fail")
 
Upvote 0
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?

Rich (BB code):
=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"
 
Upvote 0
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 !
 
Upvote 0

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.
 
Upvote 0
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.
 
Upvote 0
How about


Excel 2013/2016
ABCDEF
1Mark1Mark2Mark3Mark4Mark5Result
2Pass>10Pass>15Pass>20Pass>50Pass>100
3203040100200Pass
412345Fail
51112155539Fail
611223345180Fail
Sheet2
Cell Formulas
RangeFormula
F3=IF(AND(A3>10,B3>15,C3>20,D3>50,E3>100),"Pass","Fail")
 
Upvote 0

Forum statistics

Threads
1,224,874
Messages
6,181,511
Members
453,048
Latest member
engkinooi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top