Excel Pass or fail

[sanjay1992]

Hello sir. I have a problem, we have 7 subject(English, maths, hindi, social, environment, science and grammar)
A student have to pass english (compulsory) to be promoted. He can fail in any other 2 papers. Please help me to set the formula (condition)

 

[Becky]

You need to use the IF formula for this. You have two conditions:

1. English = pass
2. Other passes must be greater than or equal to 4.

Therefore you should also use the AND formula to ensure that both conditions are met.

https://support.office.com/en-gb/article/IF-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2
https://support.office.com/en-GB/article/AND-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9

How your formula will look depends on how you have laid out your data. I would suggest something like this:

=IF(AND([english=pass],[other passes >=4]),promoted,not promoted)