Excel Forum
Similar Content
How to Use the IF Function in Excel
Tutorial: The IF statement is a simple yet powerful tool. Today we will go through how the IF functi...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.
Tutorial: In Excel you can store values in Defined Names.  Often people use a Defined Name to refer...



Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)


Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. Use IF function to put one of two things into a cell or formulas
2. Logical Formula comes out to be TRUE or FALSE
3. Logical Test is IF functions 1st argument and it comes out to be TRUE or FALSE
4. Then you tell the IF function what you want in the cell if the test is TRUE
5. And you tell the IF function what you want in the cell if the test is FALSE
6. IF function to put one of two numbers in a cell
7. IF function to put one of two words in a cell
8. IF function for bonus
9. IF function for checking if 2 numbers are in balance





Got a Question? Ask it Here in the Forum.