How to do percentage for sale tax - Office Equipment & Supplies

101.65*0.0625=6.35$

5.98

Set up a whole new sales tax with no percentage and track those items for take out to that tax code

Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?

Calculate the amount if you know the total and percentage For example, if you purchase a computer for $800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
   Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
   Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

Simple way Amount/Total*100

The manual for the casio 262 can be found here:

http://www.casio4business.com/sa/products/downloads/manuals/PCR262_E041206B.pdf

Go to Page 11 in the manual for an explanation on how to program your sales tax based on state tax rates or a flat rate percentage (say 7%).

Press the [ac] button, then press and hold the [tax+] button for a second or two. Then enter the tax rate you want as a percentage. You would enter 8.25% sales tax as 8.25 for instance. Then press the [%] key to set the rate. Notice that printed above the [tax+] button is "tax rate" and above the [%] key is "rate set" as a reminder of which key to press.

Hi nastyguy3000;

To calculate a percentage in excel you simply take
amount/total = percentage in your cell

Example A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20)

Have Fun

Mark

Don't forget to leave a rating.

VAT is value added tax which is straight percentage. program tax one or two for the percentage and make sure your departments are set up taxable or non taxible. prgm 2 is vat probably and program 1 will be for dept. generally with casio.

Hi.
It shouldn't be difficult, as this is a simple model. I need to know what sort of business it is used in, then I can help you to set it up the usual way. How many taxes do you have, and what percentages?

Mark