Page 1 of 1

If statement in Ms excel

Posted: 05 Feb 2019, 22:46
by shreyanshh
It is a logical function with outcomes different than TRUE and FALSE.

CASE- suppose if the company has the data of amount of sales by different sales agents and wants to give a commission of 500 to every agent who made a sale of more than 25000.

This function has three Arguments which are-

1-logic_test - this will be the condition which we want to check. In the above case, it will be sales data > 25000.

2- Value if TRUE - this will be the outcome which we want if our required condition is matched. The outcome can be a number, text or even a formula.
In the above case, it will be 500, as we want to give a bonus of 500 to every agent who made a sale >25000

3- Value if FALSE - this will be the outcome which we want if our required condition is not matched. The outcome can again be a number or a text.
In the above case, it will be 0, as we do not want to give anything to the agents with sales less than 25000.

Sent from my S6s using Actuarial Info mobile app