Radio button for multiple formulas

[daniel.thomas10]

Hi, Thanks to some help my work sheet is almost finished....
but one last problem i need to solve.

I have attached the worksheet and hopefully you can see what i am trying to attempt.


in row 34, columns "G" to "R" I need a a drop down radio button that is hidden till the cell is selected.

when selected it needs 2 options "standard or gold"

if you select standard it looks up the relevant cells and does the maths which i think i can do.


example

you select cell G34 and then standard on the drop down menu... it will look up the following
cell C7 x D7 divided by 1,000,000 x 20 = (x60 if you press gold)

next to it N34 does the same but using cells c8 and d8 and so on and so on.

i think you can see what i need to achieve, bit of a pain this one

thanks in advance