Beginner - Click a checkbox then calculation to be done automatically

[Mona (Yahoo)]

Hi all,

I'm a beginner to excel ... would anyone please give me some help?

I have added in two checkboxes on a sheet and if the user clicks
checkbox 1, then cell C10 will show the answer of cell B5*5%.

If the user clicks checkbox 2, then cell C10 will show "0" (zero).

Thank you very much in advance.
M

 

[Dave Peterson]

Since you're using checkboxes, what happens if both are checked.

It kind of sounds like you could use a single checkbox and just look to see if
it's checked or not checked.

I'd use a linked cell. How you do this depends on which checkbox you used --
the checkbox from the Forms toolbar or the checkbox from the control toolbox
toolbar.

Then you can use that linked cell in a formula in C10. If x99 is the cell you
used, the formula in C10 may look like:

=if(x99=true,b5*5%,0)

If the options are mutually exclusive, this could work ok.

ps. If you have follow-up questions, please include the version of excel you're
using. It could help with the details.