A Checkbox Question

**Rick K** · 08-18-2009, 01:32 PM

Hi,
The attached spreadsheet is a product return form that I am creating. The 4 checkboxes (highlighted in yellow) are to be used if we are to add a restocking fee. Only one checkbox is supposed to be selected at any given time. The checkboxes on the left are irrelevant in this case.

I pointed the first checkbox to cell O25, which when TRUE, activates the formula in cell K48 (calculates a 15% restocking fee and then deducts it from the return amount).

My Dilema: If I point the 3 subsequent checkboxes to cell O25, then ALL the checkboxes show a checkmark, even if only one is clicked.

Can someone one point me in the right direction is to how to make the checkboxes work correclty? I left all the checkboxes pointed to O25; wasn't sure how I should've posted that.

Thanks
Rick

**martindwilson** · 08-18-2009, 01:51 PM

dont point them at the same cell! refer them to diferent cells
also if you choose option button instead and put them in a group box only one can be selected in that group box at anyone time and the linked cell will change depending on whick button clicked

**Rick K** · 08-18-2009, 02:23 PM

Thank you for the reply.

I see what you mean about that, but then how does the formula in K48 work? That formula sums and calculates the restocking fee based only on the TRUE/FALSE condition in cell O25.

If there are 4 different TRUE/FALSE conditions, how does one point to the correct one?

As far as the Dropdown Box, etc., I'm sort of stuck with this format - long story...

Thanks
Rick

**martindwilson** · 08-18-2009, 03:11 PM

one way
leave check boxes as they are ,link to 4 different cells then use
=IF(OR(O25,O26,O27,O28),SUM(K35:K47)*0.015*-1,0)

or use 5 option buttons grouped
linked to one cell
first 4 would be your choice last could be a clear all or not applicable or such and use
=IF(OR(O25={1,2,3,4}),SUM(K35:K47)*0.015*-1,0)