August 2, 2021

How to use IF formula in excel

If function is a logical test function which you can apply on a cell in an excel. It tests the given condition and returns one value if the condition is true and another value if the condition is false. For example we have few samples which are run through a scanning test and their scores are recorded.

Samples are considered as ‘PASS’ if their scores are >=50 . If their scores are less than 50,they are identified as ‘FAIL’. In order to apply the formula for subsequent cells drag the box.

Here is the outcome of IF formula.

Leave a Reply

Your email address will not be published. Required fields are marked *