RE: Excel 2007 IF function
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