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.