I need a formula to back calculate a starting number when I have an ending number after fee & taxes

Discussion in 'Algebra' started by LongTooth, Dec 4, 2022.

  1. LongTooth


    Dec 4, 2022
    Likes Received:
    Sorry if this will be too easy a question for most of you but my algebra classes were thirty-some years ago. I recently bought a couple things at an auction. I didn't think to factor in auction fee and taxes to my "max bid" so I ended up paying a good sum more than I planned. They add a 16% auction fee to your winning bid, then the tax (local and state together) is 9.25% of your bid + fee. Your total is the bid + fee + tax. I put together an Excel spreadsheet in which I can enter up to ten different items and it will calculate the fee, tax and total cost for each item as well as for all items together. That was easy.
    Total cost = bid + fee + tax
    Total cost = bid + (16% of bid) + (9.25% of (bid + fee))
    Total cost = bid + (16% of bid) + (9.25% of (bid + (16% of bid)))
    Sorry if I got carried away with parenthesis.

    Then I thought, what about making a spreadsheet calculator that would let me put in the maximum cost I would be willing to pay for an item so it would deduct the taxes and fee to give me the maximum bid amount I could enter to wind up at the maximum total cost. I've been puzzling over how to flip that equation around to solve for the bid amount for a couple hours now and concluded that I can't remember enough of my old algebra classes to make it happen.

    If someone here could help me out with that I'd sure appreciate it. Once I know what to do mathematically I can sort out how to put the math functions into the spreadsheet.

    I tried to upload the spreadsheet file in case that would be useful but the upload function is not set up for receiving spreadsheets so I've uploaded a couple pictures of the spreadsheet, one normal view and one with the cell formulas showing.

    Thanks in advance.

    Attached Files:

    LongTooth, Dec 4, 2022
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.