Another Excel function that you are highly unlikely to use on its own is the MID function: it loves to pair up with other functions to solve problems! You should…

Excel’s TRUNC function simply cuts any and all decimals off a number leaving you with an integer. There is only one argument for the TRUNC function: a reference to the…

In the very unlikely event that you have a column of Roman numerals that need to be converted to “normal” numbers, you can haul Excel’s ARABIC() function out of the…

Joining strings together is far easier than splitting them up (think the LEFT, RIGHT and MID functions). This is one of the reasons you are for example always instructed to…

This function takes multiple arguments and all the arguments must return TRUE for the function to return TRUE. You will most likely find this function combined with another function, as…

This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form questionnaire is being analysed. A closed question required respondents to select 3 of…

Using one Excel function as an argument for a second Excel function is an important skill to master. This process can become fairly complex, for example, a Nested-IF statement. Here…

Below is a simple, self-explanatory example of using the COUNTIF function to evaluate a range of data. The COUNTIF function counts the number of values in a range of cells…

When using Excel logic functions such as COUNTIF and SUMIF which involve ranges being evaluated based on criteria, you cannot select the criteria from the range of data you are…

In the example below I have used three Microsoft Excel functions to identify and then correct a common mistake that occurs when first name and surname are captured in a…