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

Example

For example;-

IF (C5<=40,”Fail,” “Pass”) where C5 contains minimum marks required to pass a test.