Results 1 to 5 of 5

Trying to calculate tax and grat involved in set selling price.

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2010
    Location
    La Penita de Jaltemba, Nayarit. MX
    MS-Off Ver
    Microsoft 365
    Posts
    19

    Trying to calculate tax and grat involved in set selling price.

    I would like to be able to key in a total price which includes a 5% tax and a 15% gratuity, and shows the actual amounts for the tax, grat and the selling price

    For instance

    If the total sale including selling price, 5%tax and 15%grat = $1
    5%tax would be $.05
    15%Grat would be $.15
    and actual sell price would be $.80

    I tried to make a spreadsheet that I can type in an all-inclusive price and the calculations would break down the actual sell price amount, tax amount and grat. amount, but the numbers are not working properly for the 5%tax and 15%grat.

    Could someone please have a look and tell me where I have gone wrong please?

    Appreciate it!

    Jim
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1