I AM TRYING TO CREATE AN INTERACTIVE CALCULATOR FOR EMPLOYEES TO USE FOR
BENEFITS OPEN ENROLLMENT. I WANT THE EMPLOYEE TO SELECT A RADIO BUTTON
ASSOCIATED W/THE COST OF EACH BENEFIT THEY WANT. HOW DO I GET THE RADIO
BUTTON TO REFERENCE A CELL WITH A PREMIUM IN IT?

There are three kinds of radio buttons in Excel. 1. Forms toolbar 2.
Controls Toolbox toolbar. 3. UserForms. The first two kind go on
worksheets and have a cell link or linked cell property. The third has
a ControlSource property that can link to a cell. The value in the
cell is true/false or a number indicating which one of a set of
buttons is elected. So the cell could not have a premium in it, but
you might devise a way to decide the premium based on what is in the
linked cell(s).

Hth,
Merjet