Scribd
Upload
30 views18 pages

Excel If and Statement

The document is a sample workbook demonstrating how to use the IF and AND functions in Excel to evaluate multiple conditions within a single formula. It includes various examples such as basic formulas, nested statements, and case-sensitive conditions. The workbook also features data tables showcasing order statuses, amounts, and delivery dates relevant to the IF AND applications.

Uploaded by

okpala rita
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
30 views18 pages

Excel If and Statement

The document is a sample workbook demonstrating how to use the IF and AND functions in Excel to evaluate multiple conditions within a single formula. It includes various examples such as basic formulas, nested statements, and case-sensitive conditions. The workbook also features data tables showcasing order statuses, amounts, and delivery dates relevant to the IF AND applications.

Uploaded by

okpala rita
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Sample Workbook for IF AND statement in Excel

The workbook shows how to use IF together with the AND function in Excel to check multiple conditions in one formula.

Author
Last update
Tutorial URL

Examples:
• Basic IF AND formula
• IF greater than AND less than
• Find dates between 2 dates
• IF AND, then calculate
• IF with multiple AND conditions
• Nested IF AND statements
• Case-sensitive IF AND formula
• IF AND OR statements
mple Workbook for IF AND statement in Excel
rkbook shows how to use IF together with the AND function in Excel to check multiple conditions in one formula.

[Link]
5-Oct-18
IF AND formula in Excel

AND formula
er than AND less than
tes between 2 dates
then calculate
multiple AND conditions
IF AND statements
nsitive IF AND formula
OR statements
Order no. Progress Delivery date Status
101 Delivered 9/1/2018 Closed
102 In transit Open
103 Unknown Open
104 Delivered Open
105 Delivered 9/12/2018 Closed
106 In transit Open
107 Delivered 10/2/2018 Closed
Order no. Amount Flag Min 50
101 $99 x Max 100
102 $49
103 $85 x
104 $100 x
105 $220
106 $50 x
107 $65 x
Order no. Delivery date Flag From 10-Sep-18
101 1-Sep-2018 To 30-Sep-18
102 12-Sep-2018 x
103 4-Sep-2018
104 24-Sep-2018 x
105 5-Oct-2018
106 26-Sep-2018 x
107 30-Sep-2018 x
Order no. Amount Status Bonus 10% bonus on conditions:
101 $99 Closed $0 Status Closed
102 $120 Closed $12 Amount over $100
103 $85 Open $0
104 $100 Closed $10
105 $220 Closed $22
106 $50 Open $0
107 $65 Closed $0
Order no. Amount Status Delivery date Flag
101 $135 Closed 1-Oct-2018
102 $140 Closed 12-Nov-2018
103 $85 Open 4-Oct-2018
104 $100 Closed 24-Oct-2018
105 $220 Closed 5-Nov-2018
106 $50 Open 26-Sep-2018
107 $65 Closed 30-Dec-2018
Order no. Shipment EDT (days) Rating Shipment ETD
101 $10 1 Excellent Poor >$30 >5
102 $49 3 Average Excellent <$20 <3
103 $16 6 Average Average all other orders
104 $19 2 Excellent
105 $30 1 Average
106 $50 10 Poor
107 $15 3 Average
Order no. Customer Amount Flag Customer Cyberspace
101 Health Center $135 Amount over $100
102 CYBERSPACE $140
103 Cyberspace $85
104 Health Center $100
105 Cyberspace $220 x
106 Health center $50
107 cyberspace $165
108 CYBERSPACE $230
109 Cyberspace $110 x
Order no. Customer Amount Flag Customer 1 Cyberspace
101 Health Center $135 x Customer 2 Health Center
102 Cyberspace $140 x Amount over $100
103 IT Service $85
104 Health Center $65
105 Cyberspace $220 x
106 Health Center $50
107 Cyberspace $65
108 IT Service $230
109 Cyberspace $110 x

You might also like