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
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(range,"criteria") =SUMIF(B1:B4,">=40") - to add up only those values in a range
=COUNTIF(range,"criteria") =COUNTIF(B1:B4,"South Africa") - to count up only those values in a range