Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHECK BOX - Can I use it as a sales tax yes or no calculation ?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHECK BOX - Can I use it as a sales tax yes or no calculation ?
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 (DataValidation, 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"),"",TaxValueFormu la) (rename names in example formula with cell references and your tax value formula) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "mastequila" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculation sales of particular month among months of sale | New Users to Excel | |||
calculation sales monthwise | New Users to Excel | |||
Sales V Commission updated calculation | Excel Discussion (Misc queries) | |||
Commission Calculation | Excel Worksheet Functions | |||
Re-arrangement | Excel Discussion (Misc queries) |