we are going to talk about the indirect function the indirect function works so that you referenced one cell would be another
cell this works fine when you're trying to change data for a formula without
actually changing the formula so using the indirect function you go equals indirect so we are going to see what cell is referenced in A2 here in A2 it says b2
And we are going to close the bracket and press enter and see it says 45 if we change b2 to lets say d2 then it becomes 100 so lets change this back to b2
So let's do a formula here so lets say that these are the staffing levels for the different seasons and lets say that this
that this is the insurance rate that we are charged for each of our staff so let's write a formula here
we are going to go open bracket and another open bracket indirect and we are going to select A2 and we are going to close that bracket
and we are going to close that bracket and then we are going to close the whole thing
and then we are going to times it by 2000 and then we are going to divide it by the numbers here
so what we are going to do is indirect again opening bracket indirect of A3 and we will close this and we will close our indirect and press enter
and there you have the formula calculated now this is not a huge formula and not a huge sheet
but if it was it would be a lot easier we will change this to C2 and there you see theses are the figures that are calculated for spring
bring john is a supervisor's so with this you have the formula and reference
to who the supervisor is you can simply change C2 to d2 change it in your reference cell press enter and here you have the calculation for summer and the supervisor for summer