|
|
Featured Tutorial
Featured Macro
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
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