Data Analyst and Technical Consultant

More Logical Excel Functions

Here are five logical functions to use in Excel that will help you answer questions based on one or more conditions

Excel IF Statements

If you want to specify the values within a cell depending on whether a condition has been satisfied, but you don’t want to be limited to just TRUE or FALSE outcomes like with the AND or OR functions, then you can use the IF function.

 

The IF function needs 3 parameters:

  • The test – using operators from the table below
  • The result if the test is TRUE
  • The result if the test is FALSE

 

=IF(test,"true","false")
=IF(B2>C2;"Win","Lose")

 

logical-functions-excel

 

Nesting simply means to combine formulas, one inside the other, so that one formula handles the result of another.

=IF(B5>1000,"Platinum",
IF(B5>300,"Gold",
IF(B5>75,"Silver",
IF(B5>25,"Bronze",
"Starter"))))

 

logical-excel-statements

 

SUMIF

=SUMIF(range,"criteria")
=SUMIF(B1:B4,">=40") - to add up only those values in a range

 

logical-excel-statements

COUNTIF

=COUNTIF(range,"criteria")
=COUNTIF(B1:B4,"South Africa") - to count up only those values in a range

 

logical-excel-statements