## 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

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

## Intro to the FIND Function

Formula Friday #11 Formula Fridays are short reads, spotlighting a single formula that you can start using straight away. Today we’re looking at the FIND Function I first started