How to do an IF-THEN formula in Excel?

1.	How to do an IF-THEN formula in Excel?
Answer» 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. Example For example;- IF (C5&LT;=40,”FAIL,” “Pass”) where C5 contains minimum marks required to pass a TEST.

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

Example

For example;-

IF (C5&LT;=40,”FAIL,” “Pass”) where C5 contains minimum marks required to pass a TEST.

Discussion