IF formula in Excel | Video #3
This video will help you to logical evaluate a cell based on a criteria by using IF function
The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result
They are 3 arguments in IF function
1. Logical test: It is the logic that you want if function to test
2. Value if true: if the logic is true, what you want if function to input
3. Value if false: If the logic is false, what you want if function to input
IF your IF formula is not giving you the desired results then one of the common mistakes is the "else" argument. That's the second (Value if true)and the third argument (Value if false). Make sure you have given inputs to all the three arguments in IF function. Specify what should happen "if" the condition met and isn't met.
Hope you have liked the video. Thank you for watching
Subscribe to my channel for more video updates:
/ @excelwithkumar
Excel Beginner to Intermediate within 60 minutes playlist:
• Getting started with Excel - The Beginners...
#MicrosoftExcel
#Ifformula
#ExcelwithKumar