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")``````

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"))))``````

## SUMIF

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

## COUNTIF

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