There will come a time when using Google Sheets where you will be checking the value of a cell against multiple criteria, which one is the best to use? There are three handy functions you can use within a single cell to handle multiple conditions: IF, IFS and SWITCH. Let’s examine each formula individually and …
Recently I had a column of names in a spreadsheet with the following structure: Last Name, First Name and they needed to change to the structure: First Name Last Name. For example, the original structure of someone’s name would be Smith, John and this needed to change to John Smith. So a couple of medications …
I recently had an exercise where I needed to extract all the text from an OmniGraffle document. The task at hand was to check a beautifully designed organisation chart against a spreadsheet list of staff. Doing this task manually was going to take far too long. There had to be a better way of extracting …
To convert a string to an integer you use the handy int() function. For example, if you have a string such as “79” and you insert this like so into the int() function: int(“79”) you get the result 79. But what happens when you don’t have a string that easily converts into a number? Here …
One of the first formulas I started with when exploring more about the functionality of spreadsheets is the IF formula. The IF formula is easy to understand and contains only three parameters which are all required. The first parameter is the condition to check, the second is the returned value if the condition is true, …
How do you check if a cell is empty or blank in Google Sheets? There is a handy function called ISBLANK which enables you to check if a cell is empty. What Does Empty Really Mean? In Google Sheets there are two ways of having an empty cell, one way is by defining an empty …