How to do an IF-THEN formula in Excel?
Formula or syntax of the if-then statement in MS Excel-
IF (Logic_Test, Value_if_True, Value_if_False) where expression to be evaluated is denoted by Logic_Test.
BY Best Interview Question ON 01 Apr 2019
IF (C5<=40,”Fail,” “Pass”) where C5 contains minimum marks required to pass a test.