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