## 220219

220219 I am grieving My mum passed away in November 2021. We’ll get to know eachother better before we go into all the details.The video you are about to watch is me crying, whil

## IFERROR vs ISERROR

Formula Friday #20 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. I’m sure a fair few of you will be familiar with IFERROR

## Using Goal Seek to Forecast OTB Margin

Formula Friday #19 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. This post is about a tool more than a formula. We’re goi

## How to use the Substitute Function

Formula Friday #18 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. Today we’re going to be looking at the SUBSTITUTE Functi

## Adding Subtotals to your data

Formula Friday #17 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. I don’t know about you, but I often forget there are oth

## How to use the LEFT and RIGHT Functions

Formula Friday #16 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. There are a handful of text functions that come in really

## How to use AND, OR & IF Functions

Formula Friday #15 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. Sometimes you will need an IF statement to be dependent on

## How to use nested IFs

Formula Friday #14 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. Get a hot beverage, a piece of paper and a pen. This is th

## Getting started with IF statements

Formula Friday #13 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. Today we will cover the basics of IF statements There is a

## SUMIFS. The People’s favourite Function

Formula Friday #12 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. SUMIFS is hands down the function I use the most Once you