Online Instruction Page
IF Function http://www.contextures.com/xlfunctions06_excel-if-function.html
Related tutorials
Tables http://www.contextures.com/xlExcelTable01.html
VLOOKUP http://www.contextures.com/xlFunctions02.html
Related Contextures Product
30 Functions 30 Excel Functions in 30 Days eBook Kit
Examples
1 Check for Empty Cell
2 Nested IF - check 2 cells
3 IF With Check Box
4 More IF Examples
Get weekly Excel tips, tutorials, videos, and news
Contextures Excel Newsletter
IF Function -- Example 1
Check For Empty Cell
Product Price Qty Total
Sweater 15 10 150
=IF(D7="","",C7*D7)
IF D7 is empty (""), the total will be empty ("")
Otherwise, multiply Price x Qty to calculate the Total
IF Function -- Example 2
Check 2 Cells (Nested IF) -- Named Excel Table
Product Price Qty Total Structured References
Sweater =IF([Price]="","",IF([Qty]="","",[Price]*[Qty]))
Jacket 10
Pants 15 Normal Cell References
Shirt 15 10 150 =IF(C7="","",IF(D7="","",C7*D7))
IF Price is empty (""), the total will be empty ("")
IF Qty is empty (""), the total will be empty ("")
Otherwise, multiply Price x Qty to calculate the Total
IF Function -- Example 3
Apply Tax for Local Orders
Product Price Qty Total
Coat 65 1 65.00
Pants 25 2 50.00
Subtotal 115.00
Sales Tax? ✘ 1
Tax 11.50 10%
Total 103.50
How to add and link a Check Box
http://blog.contextures.com/archives/2013/07/09/use-check-box-result-in-excel-formula/
<== Linked to the check box
<== Tax Rate
Use Other Functions
Instead of using complex nested IF formulas, other
functions can help with lookups
To find the product name based on the product code, use INDEX and MATCH
INDEX / MATCH http://www.contextures.com/xlFunctions03.html#IndexMatch
To find a letter grade based on a student's numeric grad, use VLOOKUP
VLOOKUP http://www.contextures.com/xlFunctions02.html#Range
More IF Function Examples
The IF function can be combined with many other
functions, for powerful formulas
MAX IF http://www.contextures.com/excelminmaxfunction.html
IF and FORMULATEXT http://www.contextures.com/excelisformulafunction.html
(Excel 2013 or later)
IF and INDIRECT http://www.contextures.com/xlFunctions05.html
IF in Pivot Table Formulas http://www.contextures.com/excel-pivot-table-calculated-field.html
Contextures Products
Pivot Power Premium Add-in
UserForms for Data Entry ebook Kit
Contextures Excel Tools Add-in
Data Entry Search Popup
Data Entry Popup
30 Excel Functions in 30 Days eBook Kit
Contextures Sites & News
Contextures Excel Newsletter
Contextures Excel Tips Website
Contextures Excel Blog
Excel Pivot Tables Blog
Other Excel Products
Contextures Recommends
www.contextures.com 06/29/2019
Time-saving tools for pivot table power users
Step by step instructions and videos
Make instant backups, sort sheets, and many more tools
Makes data entry easier when choosing from long list
Select single or multiple items from a listbox, to enter in a single cell
Sample workbook and easy to follow user guide for key Excel functions
Weekly Excel tips, tutorials, videos, and news
Hundreds of tutorials, tips and sample files
Read the Excel tutorials and share your comments
Pivot table tutorials and tips, with comments and questions
Other Excel tools and training, recommended by Debra
www.contextures.com 06/29/2019
