Checkboxes to calculate tax

[city_girl4you]

Hi All,

I'm hoping somebody can help me. I created a template of a contract and within it I have created checkboxes to indicate which taxes to apply to the total. In some cases the customer would be exempt from paying one or more taxes. There is a checkbox for each tax.

I don't know how to do the calculations if the box is checked. For instance:

Checkbox 1 - (PST exempt?) if they are then $0.00 if they're not, then Subtotal x 8%

Checkbox 2 - (GST exempt?) if they are then $0.00, if they're not, then Subtotal x 6%

I'm so frustrated trying to get this to work. HELP!!!

 

[Domski]

Hi,

Right click on the check box and select the Contol Tab. Link the control with a cell, e.g. A1.

Now assuming the subtotal is in B1 you can use a formula like this:

=IF(A1=TRUE,0,B1*0.08)

The linked cells can be out in a hidden column so as they're out of sight.

Dom

 

[Barry Katcher]

Right-click on your checkbox. Select Format Control, then the Control tab. In the Cell link: box, enter a cell address of a cell that is out of view of the invoice (cells H11 and H12, respectively, in the sample below). Now, if either of the checkboxes are checked, their respective linked cells will return TRUE. If not checked, the cells will return FALSE.

Now, you can use these formulas (which refer to the sample below):
Formula in C11 is: =IF(H11=TRUE,"",$C$10*B11)
Formula in C12 is: =IF(H12=TRUE,"",$C$10*B12)

The sample below has both of the boxes un-checked.

Book1
	A	B	C	D	E	F	G	H
9
10		Subtotal	100
11	PST Tax	8%	8					FALSE
12	GST Tax	6%	6					FALSE
13			114
14
Sheet1

EDIT: Dom, you're just too fast for me. Must be all of those muscles.

 

[city_girl4you]

Thanks A BUNCH!!

Thanks soooooo much Domski and Barry. It worked!! Thanks again. It was greatly appreciated.