excel if function

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 IF function

Excel 2007 IF function

resolvedResolved · Low Priority · Version Standard

Faraz has attended:
Excel Intermediate course

Excel 2007 IF function

What is it ?

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

Attached files...

If.xls


 

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

View all Excel hints and tips


Server loaded in 0.1 secs.