Using Excel’s OR() function
This function takes two or more arguments, and one of the arguments must return TRUE for the function to return…
Using Excel’s COUNTIFS() function
You should first master the IF() and COUNTIF() functions. The COUNTIFS() function is an extension of Excel’s COUNTIF() function. In…
Using Excel’s IF() function
This simple function is a great introduction to Excel’s logic functions. We all use this kind of logic every single…
Using Excel’s AND() function
This function takes two or more arguments, and all the arguments must return TRUE for the function to return TRUE…
Advanced criteria in Excel logic functions
This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form…
Using Excel’s COUNTIF() function
This tutorial explains the COUNTIF function in Excel, which counts cells meeting specific criteria within a range, featuring syntax explanation…
Nested IF Statements in Excel
Understanding and applying nested IF statements is crucial for completing Grade 12 Excel analysis and meeting Level 4 requirements. They…