I am working in a spreadsheet that prices products.
in cell(E2) is an option button that selects a mark up of 20%(has value of 1)...under format control,,, cell link is $E$2
in cell(E3)
any help I would be grateful
in cell(E2) is an option button that selects a mark up of 20%(has value of 1)...under format control,,, cell link is $E$2
in cell(E3)
is an option button that selects a mark up of 25%
My question how do I add a third option in cell (E4) with an option button that will select a mark up of 15% ( I have inserted the option button)
I have altered formula in (P5) to +IF(E2 =1.0.20,0.25,0.15) but this does not work, it comes up with pop up window "You've entered too many arguments for this function"...under format control,,, cell link is $E$2
in cell (P5) is a formula =IF(E2=1,0.20,0.25)My question how do I add a third option in cell (E4) with an option button that will select a mark up of 15% ( I have inserted the option button)
any help I would be grateful