Using checkbox to calculate formula?

  • Thread starter Thread starter Saltman
  • Start date Start date
S

Saltman

Is there a way to setup a checkbox so that it calculates the sum in a
different box. What I am trying to do is setup a sales report with
sales tax figured in. 1 box should contain a fixed sales tax, and the
other box would be tax exempt. This way depending on which box was
checked the formula would display the proper sales tax.

I am not very advanced with excel, but know enough to get into trouble
so some direction would help me with my project a lot and I am sure I
could figure it out from there.

Thanks in advance
Jim
 
CheckBox from the Forms toolbox. linked to cell A1.
Something like :-

=IF(A1=TRUE,"Taxed","Exempt")

You can substitute the text with formulas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Income Tax 7
CHECK BOX - Can I use it as a sales tax yes or no calculation ? 1
Help please - formula to calculate Tax 4
Sales Taxes 2
Totaling the same cells from different sheets 8
SUM and IF using two date ranges 2
formula for taxing 3
How can sales tax be formulate in a invoice 2

Back
Top