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<=40,”Fail,” “Pass”) where C5 contains minimum marks required to pass a test.

Suggest An Answer

No suggestions avaliable!