IF
This Function tests a Condition.
If the condition is met it is considered to be TRUE, else FALSE
Syntax : IF(condition,ActionifTrun,ActionIfFalse)
IF is one of the most powerful function in Excel, if anyone understood the if function well they can do their own answer what they want to show...