How to use the IF function

In Excel, the “IF” statement is a logical function that allows you to test a condition and return one value if the condition is true and another value if the condition is false.

logical_test is any value or expression that can be evaluated to TRUE or FALSE
value_if_true is the value that will be returned if the logical test is TRUE
value_if_false is the value that will be returned if the logical test is FALSE (optional)

In our example, we are wanting to determine if a value in Column B is Greater or Less Than 150

This formula tests if the value in cell B3 is greater than 150. If it is, the formula returns “Greater”; otherwise, it returns “Less Than or equal to 150”.

Any questions? Request a call-back

Request a call back and we will phone you back within the next 24hrs

We Value You

We conduct our business with the highest standards of ethical values and always respect our clients, ensuring that their business requirements are achieved and that their expectations are exceeded. These values are at the core of our company culture and guide our actions and decisions.

How to use the IF function

Any questions? Request a call-back

We Value You

Contact Us

Connect With Us