Operation with two conditions

If you want to make an operation but you consider two conditions you can use IF() and AND() formulas.

Here, you get the result of  passing or failing condition by controlling the data in C and D column.

If the first data is bigger than 300 and the second data is bigger than 500, the result is "passed", otherwise the result is "failed".

AND() function provides to consider two conditions whereas IF() formula provides to give a respons according to the condition.

Related Trainings

Practice: IF Functions 3 - Other Functions and If

Practice: IF Functions 3 - Other Functions and If

Making more practice by using IF() function.


Practice: IF Functions 6 - Students

Practice: IF Functions 6 - Students

Making more practice by using IF() function.


Privileged Customers

Privileged Customers

Matching nested IF() and IFS() functions.