How to Calculate Tax Gratuity in Excel

1. Label your Excel spreadsheet columns, if desired. For example, you can type 'Sale' into cell A1, 'Tax' into cell B1 and 'Gratuity' into cell C1. You can choose your font type, size and style from the formatting toolbar. You can also choose to center your typing or justify it to the right or left. If the formatting toolbar is not showing, select the 'View' tab from the top then 'Toolbars' from the drop-down menu and select 'Formatting.'
2. Format the Excel worksheet to display how you prefer. For example, to format the second row to display a dollar sign and two decimal places, click on the '2' at the beginning of row 2. Select the 'Format' tab from the top, and in the drop-down box choose 'Cells.' From the 'Category' box, choose 'Currency,' and in the 'Decimal places' box, select '2.' In the 'Negative numbers' box, choose how you prefer negative numbers to display, then click 'OK.'
3. Enter the taxable sale amount into a cell in your Excel worksheet. For example, if your taxable sale amount is $30, enter '30' into cell A1. With the suggested formatting above, Excel will display '$30.00' in the cell.
4. Create a formula to calculate the correct amount of sales tax. For example, if your sales tax rate is 5 percent, enter '=A2*.05' into cell B2. This formula tells Excel to multiply — denoted by the asterisk symbol — the value in cell A2 by .05, which is the decimal value of 5 percent. Cell B2 should now display '$1.50.' This is the amount of sales tax you owe on a $30 sale at a 5 percent tax rate.
5. Create a formula to calculate gratuities at your desired percentage. For example, if you want to pay a gratuity of 20 percent, enter '=A2*.2' into cell C2. This formula instructs Excel to multiply the value in cell A2 by .2, which is the decimal value of 20 percent. Cell C2 should now show '$6.00' as your desired gratuity amount on a $30 sale at a 20 percent tip rate.