IF Function / Formula in MS Excel 2007, Excel IF Formula / Function.

IF Function in MS Excel / Excel IF Formula or Function / How to use IF Function in Excel 2007.

IF Function is one of the most important Function / Formula in MS Excel. Here we will learn / use IF Function. How to use IF Function or Formula in Excel? What are the parameters or arguments of IF Function in Microsoft Excel Software?  What is the syntax of IF Function? How many types of IF Functions / Formulas in MS Excel?

So, In MS Excel IF Formula or Function has three arguments or you can say parameters. IF Function syntax is =IF(logical_test, [value_if_true], [value_if_false]).

Logical Test should be something like that comparing to different cells or comparing a cell with a value. You can also comparing a cell with a Formula or a Text entry.

There are four types of IF Functions or Formulas. Now here we are going to learn how to use simple IF Function in MS Excel?

We have a data that has employees details like Employee Name, Salary, Bonus, Job Rating etc, And in this data we want to know the bonus of the employees according to their Job Rating. Lets say, the employees that have Job Rating 4 or 5, they will get 2000 Rs as bonus.

Here is a condition that If your Job Rating is 4 or 5, we are going to put the value 2000 in the bonus column if not Zero (0). So, here we use IF Formula i.e

=IF(F2>3, "2000","0").

In the above Formula the condition is If  F2 column values that contains job rating of the employees is greater than 3(>3), then Employee will get Bonus 2000 else 0.

NOTE:- The value after the If condition should be in double quotes ("") like "2000", "0".