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

excel if function

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

Excel 2007 IF function

ResolvedVersion 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:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.