What is IF Formula in EXCEL SHEET ?

The IF formula is  used to determine whether a condition specified by you turns out to be

•  True

•  False. 

This can be useful if you need to evaluate a decision based on supplied data.

Syntax for the IF formula

The syntax for the IF formula is as follows: IF(logical_test, [value_if_true], [value_if_false])
  

What is logical_test ?

• The logical_test is the condition that you would be checking against. In this case, we are checking to see if the product does not have a tax attached to it.

What is value_if_true ?

• The value_if_true is the value displayed if the test turns out to be true. In our case, we calculate the final sales of the item. (Multiply the unit price by the amount of units sold.)

What is value_if_false ?

• The value_if_false is the value displayed if the test turns out to be false. In our case, we calculate the total sales, then add the tax to determine the final sales.

 If you want to know other tricks about excel sheet

• How to add drop down list in excel sheet ?