View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mastequila mastequila is offline
external usenet poster
 
Posts: 2
Default 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