Kelli Webb
Member
Hello, I hope you are travelling ok with the current global lockdown
I have figured out how to do the multiplication I required based on one Award Level i.e. LSA
The value in C5 should be based on the
Award & Level selected in C3 x
(Select the Age in E7, I need this to apply the relevant % from the table in K2:M15) x
Multiplied by the Adult rate in C12:C16
The correct answers are between column E & I based on the Award Level & age selected
I find it so hard to articulate what I want to do, which I feel is just as bad at trying to figure out the calculation.
Any questions, please don't hesitate to ask.
thank you, as always forever in your debt.
Kelli
I have figured out how to do the multiplication I required based on one Award Level i.e. LSA
The value in C5 should be based on the
Award & Level selected in C3 x
(Select the Age in E7, I need this to apply the relevant % from the table in K2:M15) x
Multiplied by the Adult rate in C12:C16
The correct answers are between column E & I based on the Award Level & age selected
I find it so hard to articulate what I want to do, which I feel is just as bad at trying to figure out the calculation.
Any questions, please don't hesitate to ask.
thank you, as always forever in your debt.
Kelli