In this workout, we're going to practice the offset function as a scenario picker. So I start my offset function by deciding my starting point, my reference cell. Well, I know I want to choose one of these three scenarios as my eventual output. That means I need a cell somewhere around it. I'm going to choose the cell immediately above. It now asks me how many rows do you want to go down? Well, I could say I want to go down 1 and I could hard code in the 1, let's do that just initially. And then it asks me, how many columns do you want to go to the right? I don't want to go any columns to the right. I want to go down immediately to the 10%, 6%, or the 3%. Cool, so I put in a zero. I'm going to leave out the height and width. So that returns the 10%. I could go in, change the scenario picker to 2, gives me the 6% or change it to a 3.

But, it's very annoying having that hard-coded figure within the formula. Instead, let's change that scenario picker so it's outside the formula and my scenario picker's easily seen in cell C4. I can now change my scenario picker from 1 to a 2 to a 3, 1, 2, 3, and my offset function gives me the value within that cell reference. Let's see how flexible the offset function is. Let's say I want to add in an alternative case of 2%.

I can now just put a 4 into the scenario picker and it will go down to the 2%. I could now add in another one, alternative case 2, my scenario picker I changed to a 5, and it goes down. So very flexible. This function allows my scenarios to grow as my model grows.