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...