What is it ?

Dear Faraz

Thank you for attending Excel Intermediate training. I hope you enjoyed it.

If function is a logical function. If you have e.g. salespeople and you want to know if they will get commission then you can use this function. If you want to know how much commission they will get then you can use the IF function.

Please find attached Excel file for your reference. The explanation is as below:

The syntax of an IF statement is =IF(Logical Test, TRUE, FALSE)

If you observe Cell G7 you will notice that the Function is =IF(F7>10000,"YES","NO")

= this is used for any formula or function
IF is the name of the function
(F7>10000 is the Logical test
, is used to separate the logical test from the TRUE Value
“YES” is the value that should be returned if the value in cell F7 is TRUE
,is used to separate the TRUE statement from the FALSE
“NO”) is the value that should be returned if the value in cell F7 is FALSE.


If you look at H7 Instead of simply showing Yes and No a calculation can be performed in an IF statement. The function states that if the Sale for Bill Macarthur is more than 10000 then he should get 5 % of his sales. If less than 10000 then he should only get 1% of what he has sold.

I have intentionally used the formula view in the spreadsheet so that you can see the formulae. If you want to see the actual results in the cells then simply use the Keyboard shortcut CTRL+` ( this is located below the Esc key).

I hope this helps.

If this has helped to resolve the question than please mark this post as resolved otherwise you can click the reply button for further clarification.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003

Attached files...

If.xls