Results 1 to 20 of 20

Estimate the sales tax

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2010
    Location
    somewhere, USA
    MS-Off Ver
    Excel 2010
    Posts
    86

    Estimate the sales tax

    I have a problem. If I get a receipt from a purchase all it lists is the item price but I don't see the sales tax rate which adds the amount to get the grand total. Is there an easy way to estimate the sales tax rate and create a function to automatically estimate it's percentage if you have the grand price total?

    The first row lists the column headers

    A2 is the item price
    B2 is the unknown sales tax rate
    C2 is the grand total price of the item plus tax rate.

    If I have the item price and the grand total price...can a function be made to estimate the sales tax? Or put another way...if I have the initial sales price but don't have the sales tax rate but can't find the grand total price unless I have the sales tax...is there a way to generate a function to automatically estimate what the total cost would be if a sales tax were included?

    Thanks in advance.
    Last edited by DorothyFan1; 01-27-2011 at 08:09 AM.

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