IF Function Overview
Product ID Sales Target Sales Achieved Status
GMN112 $ 4,500.00 $ 4,800.00 Achieved
GMN113 $ 7,800.00 $ 7,500.00 Not Achieved
GMN115 $ 12,000.00 $ 12,000.00 Achieved
GMN125 $ 6,800.00 $ 4,500.00 Not Achieved
GMN144 $ 8,900.00 $ 8,700.00 Not Achieved
GMD550 $ 4,600.00 $ 6,700.00 Achieved
GMD572 $ 7,000.00 $ 7,900.00 Achieved
GMD584 $ 8,500.00 $ 9,000.00 Achieved
Sales Achieved => Sales Target : Achieved
Sales Achieved < Sales Target : Not Achieved
>>> =IF(D5>=C5,"Achieved",
"Not Achieved")
logical_test: D5>=C5
value_if_TRUE: "Achieved"
value_if_FALSE: "Not Achieved"
IF Function Overview
Product ID Sales Target Sales Achieved Status
GMN112 $ 4,500.00 $ 4,800.00 Achieved
GMN113 $ 7,800.00 $ 7,500.00 Not Achieved
GMN115 $ 12,000.00 $ 12,000.00 Achieved
GMN125 $ 6,800.00 $ 4,500.00 Not Achieved
GMN144 $ 8,900.00 $ 8,700.00 Not Achieved
GMD550 $ 4,600.00 $ 6,700.00 Achieved
GMD572 $ 7,000.00 $ 7,900.00 Achieved
GMD584 $ 8,500.00 $ 9,000.00 Achieved
>>> Do Yourself >>>
Product ID Sales Target Sales Achieved Status
GMN112 $ 4,500.00 $ 4,800.00 Achieved
GMN113 $ 7,800.00 $ 7,500.00 Not Achieved
GMN115 $ 12,000.00 $ 12,000.00 Achieved
GMN125 $ 6,800.00 $ 4,500.00 Not Achieved
GMN144 $ 8,900.00 $ 8,700.00 Not Achieved
GMD550 $ 4,600.00 $ 6,700.00 Achieved
GMD572 $ 7,000.00 $ 7,900.00 Achieved
GMD584 $ 8,500.00 $ 9,000.00 Achieved
IF Function with Calculations
Sales Person Sales Target (Units) Sales Achieved Bonus
Mike 50 55 $ 50.00
Teresa 60 45 Not Applicable
Nicolas 40 45 $ 62.50
Abigaile 55 60 $ 45.45
Martin 60 50 Not Applicable
Cris 50 50 $ -
Sarah 70 80 $ 71.43
Dalton 80 75 Not Applicable
Salary of Each Sales Person
$ 500.00
>>> Do Yourself >>>
Sales Person Sales Target (Units) Sales Achieved
Mike 50 55
Teresa 60 45
Nicolas 40 45
Abigaile 55 60
Martin 60 50
Cris 50 50
Sarah 70 80
Dalton 80 75
Salary of Each Sales Person
$ 500.00
>>
Bonus
$ 50.00
Not Applicable
$ 62.50
$ 45.45
Not Applicable
$ -
$ 71.43
Not Applicable
Use of Nested IF
Subject Marks Grade
Maths 94 A Grade System
Physics 86 A A = Above 80
Chemistry 81 A B = 70-79
Biology 78 B C = 60-69
English 68 C D = 50-59
Economics 54 D F = Below 50
Religion 47 F
Geography 56 D
>>> Do Yourself >>>
Subject Marks Grade
Maths 94 A Grade System
Physics 86 A A = Above 80
Chemistry 81 A B = 70-79
Biology 78 B C = 60-69
English 68 C D = 50-59
Economics 54 D F = Below 50
Religion 47 F
Geography 56 D
IF with NOT Function
Serial Donor Donation Medium Date Result
101 Adam $ 800.00 Online 7/26/2021 Adam
102 Mike $ 500.00 Cash 8/1/2021
104 Anna $ 620.00 Cheque 8/2/2021 Anna
105 John $ 1,100.00 Online 7/30/2021 John
110 Shelly $ 420.00 Cash 7/15/2021
112 Simons $ 450.00 Cash 7/21/2021
114 Clarke $ 550.00 Cheque 7/16/2021 Clarke
Criteria to Exclude
115 Ricky $ 300.00 Online 7/22/2021 Ricky
119 Megan $ 150.00 Cash 7/19/2021
126 Michael $ 900.00 Cash 7/28/2021
128 Cris $ 800.00 Online 8/1/2021 Cris
130 Richards $ 1,200.00 Cheque 8/1/2021 Richards
132 Andrew $ 630.00 Cash 8/3/2021
133 Josephine $ 760.00 Online 7/28/2021 Josephine
136 Amanda $ 440.00 Online 7/19/2021 Amanda
139 Brett $ 600.00 Cash 7/21/2021
140 Teresa $ 400.00 Online 7/16/2021 Teresa
>>> Do Yourself >>>
Serial Donor Donation Medium
101 Adam $ 800.00 Online
102 Mike $ 500.00 Cash
104 Anna $ 620.00 Cheque
105 John $ 1,100.00 Online
110 Shelly $ 420.00 Cash
112 Simons $ 450.00 Cash
114 Clarke $ 550.00 Cheque
Cash
115 Ricky $ 300.00 Online
119 Megan $ 150.00 Cash
126 Michael $ 900.00 Cash
128 Cris $ 800.00 Online
130 Richards $ 1,200.00 Cheque
132 Andrew $ 630.00 Cash
133 Josephine $ 760.00 Online
136 Amanda $ 440.00 Online
139 Brett $ 600.00 Cash
140 Teresa $ 400.00 Online
Yourself >>>
Date Result
7/26/2021 Adam
8/1/2021
8/2/2021 Anna
7/30/2021 John
7/15/2021
7/21/2021
7/16/2021 Clarke
Criteria to Exclude Cash
7/22/2021 Ricky
7/19/2021
7/28/2021
8/1/2021 Cris
8/1/2021 Richards
8/3/2021
7/28/2021 Josephine
7/19/2021 Amanda
7/21/2021
7/16/2021 Teresa
IF with Logical Functions
Data Type
112 Number
Mike Text
5.78 Number
Blank
Simon Text
1 Logical Value
0 Logical Value
Blank
-56 Number
*/=] Text
>>> Do Yourself >>>
Data Type
112 Number
Mike Text
5.78 Number
Blank
Simon Text
1 Logical Value
0 Logical Value
Blank
-56 Number
*/=] Text
Error Checking with IF
Dvidend Divisor Quotient With Error Checking
24 6 4 4
24 1.2 20 20
24 0 #DIV/0!
0 24 0 0
24 A #VALUE!
35 24 1.46 1.46
24 #DIV/0!
>>> Do Yourself >>>
Dvidend Divisor Quotient With Error Checking
24 6 4 4
24 1.2 20 20
24 0 #DIV/0!
0 24 0 0
24 A #VALUE!
35 24 1.46 1.46
24 #DIV/0!
IF with CONCATENATE and Ampersand(&)
Salesman Sales Target Sales Achieved Statement
Mike 50 45 Target Not Achieved, 5 Sales Short
Teresa 45 55 Target Achieved by Teresa, Total Sales: 55
John 50 60 Target Achieved by John, Total Sales: 60
Aigaile 40 45 Target Achieved by Aigaile, Total Sales: 45
Damien 55 45 Target Not Achieved, 10 Sales Short
Lucy 70 80 Target Achieved by Lucy, Total Sales: 80
>>> Do Yourself >>>
Salesman Sales Target Sales Achieved
Mike 50 45
Teresa 45 55
John 50 60
Aigaile 40 45
Damien 55 45
Lucy 70 80
>>> Do Yourself >>>
Statement
Target Not Achieved, 5 Sales Short
Target Achieved by Teresa, Total Sales: 55
Target Achieved by John, Total Sales: 60
Target Achieved by Aigaile, Total Sales: 45
Target Not Achieved, 10 Sales Short
Target Achieved by Lucy, Total Sales: 80
IF with DATE Function
Student Name Date of Payment Deadline Status
Alex 7/26/2021 In Time
Morgan 7/31/2021 In Time
Sandra 8/4/2021 7/31/2021 Delayed
Samson 7/16/2021 In Time
Tomas 8/1/2021 Delayed
>>> Do Yourself >>>
Student Name Date of Payment Deadline Status
Alex 7/26/2021 In Time
Morgan 7/31/2021 In Time
Sandra 8/4/2021 7/31/2021 Delayed
Samson 7/16/2021 In Time
Tomas 8/1/2021 Delayed
