CHECK BOX - Can I use it as a sales tax yes or no calculation ?

[Guest]

Not the most advanced at excel.
Hope someone can help. If this can be done please explain step by step.

I have added a checkbox via controlls.
If the box is checked ( true ) can I have it calculate say 8% sales tax on a
total dollar amount ??

Example of fields
Total Sale = 100.00
IL Sales Tax (check box ) = ????

I want to leave the cell blank if not checked and if possible automatically
figure the sales tax at the percent that I need if checked .. Hope I
explained this well.

Thanks Bob

 

[Arvi Laanemets]

Hi

Generally it is a bad idea to use form controls in tables - you have to
design all controls for different rows individually, you have to write the
value of every control individually to specific cell (at least I imagine
that is what you have to do), you'll have a lot of controls in your table
and probably there'll be problrms when you want to delete/add rows, etc. And
there is no need for this at all!

Apply data validation list (Data>Validation, select list) with source p.e.
"Yes" to Taxed column. Now you can select "Yes" in this column for any row,
or you can leave cell empty. To remove selected "Yes" value, clear cell
entry.

Now for TaxValue column you can use a formula like
=IF(OR(TotalSale="",Taxed<>"Yes"),"",TaxValueFormula)
(rename names in example formula with cell references and your tax value
formula)