Option Button that will calculate in a cell?

  • Thread starter Thread starter Queststation
  • Start date Start date
Q

Queststation

Hi,

How do I create a tax option button that will calculate in a cell?
This is what I have created. Taxable? Yes or No, Total Cell and Tax
Cell
if Yes then Total Cell x 8.25% in the Tax Cell
if No then don't calculate.

thanks!
 
But my option buttons are not on a cell....how do I make the code work
with them?
thank you!
 
If the choice is between a yes and no, you might want to use a single checkbox
instead.

Show the Forms toolbar from the Forms toolbar and draw a checkbox near your
cell. You can change the caption of the checkbox from "Checkbox 1" to "Check if
Taxable" (or something nice).

Then rightclick on the checkbox and select Format Control
On the control tab, you can assign a cell link.
Use the cell right under the checkbox.
and ok your way out of that dialog.

Now, if you click the checkbox, you'll see True or False in that linked cell.

Use your arrow keys to select the linked cell.
Then Format|Cell|Number tab
use a custom format of: ;;; (just 3 semicolons)

This will hide the true/false on the worksheet (but it's still viewable in the
formula bar when the cell is selected.

Now, you can use a formula that refers to the linked cell.

=totalcell *(if(linkedcell=true,8.25%,0))

like:

=b12 * (if(c22=true,8.25%,0))
 
Back
Top