How to use Conditional Formulas in Excel

  • Post author:
  • Post category:Uncategorized

Excel allows us to utilize its IFANDOR, and NOT functions to generate conditional formulas which test for true or false conditions and also make logical comparison between different expressions.

These Excel conditional formulas essentially allow us to create basic logical If (this), then (that)arguments.

Figure 1. of Excel Conditional Formulas

Formula Syntax

=IF (logical_test, [value_if_true], [value_if_false])

  • logical_test = A logical expression or value which is to be tested for being TRUE or FALSE.
  • value_if_true (optional) = The specified value to return if the logical_test is TRUE.
  • value_if_false – (optional) = The specified value to return if the logical_test is FALSE.

How to Write a Conditional Formula in Excel

Because making logical comparisons among varying expressions and testing for true or false conditions are common to lots of tasks, we can make use of the IF and AND functions to create our own conditional formulas excel.

To carry out this task, follow the simple steps below:

          1. We begin by entering the data available to us under well-labelled columns of our worksheet;

Figure 2. of Excel Conditional Formulas

In the worksheet above, our purpose is to ascertain if each student that took two separate exams, met the criteria specified by us; which in this case is a certain score set for each test.

           2. The conditional formatting if formula in cell D2 of our worksheet is as follows;
=IF(AND(B2>=20,C2.>=30),”Pass”,”Fail”)

meaning , if a student obtained a specific score in both tests (20 and 30), they would either pass or fail.

Figure 3. of Excel Conditional Formulas

          3. Modify and copy the conditional formatting if formula in cell D2 down into the other cells in column D for the other conditional results:

Figure 4. of Excel Conditional Formulas