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
Attachments

12.1 KB Views: 5