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

GYM Complaints Sheet

GYM Complaints Sheet

Master date functions using the complaints data for a gym.


Top Models

Top Models

Calculate the earnings of top models based on scenarios


Vacation Day Calculator

Vacation Day Calculator

Calculate vacation days based on years worked and other conditions