Results 1 to 8 of 8

Multiply by percentages

Threaded View

  1. #1
    Registered User
    Join Date
    12-12-2020
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    4

    Multiply by percentages

    I am working on a pricing sheet for quoting purposes. I have all the details ironed out except for one thing. I need to take the total price and multiply it by a surcharge of 9.5%. I have 2 cells 1 that says 9.5 and another that says 1.095. Right now I am having to multiply by the 1.095 to take effect but I want to be able to use the cell that says 9.5. One of two things is happening. The pricing is heavily inflated because it it taking the value and multiplying it by 9.5 the second thing is it is underpriced because it only shows 9.5% of the value. I want to be able to adjust this 9.5 cell in the future and use this cell as part of the formula. How do I do this? Is this possible?
    Last edited by LVasquez; 12-12-2020 at 09:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-28-2019, 09:23 AM
  2. Reversing input percentages against variable percentages.
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-26-2014, 08:56 PM
  3. Replies: 4
    Last Post: 01-10-2014, 09:32 AM
  4. If criteria match, multiply then sum across multiply worksheets
    By ciayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 02:20 PM
  5. [SOLVED] Multiply, Divide and Then Multiply in a cell
    By Brownie2576 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-22-2012, 08:57 PM
  6. Multiply multiple percentages in one formula
    By rdd2 in forum Excel General
    Replies: 0
    Last Post: 03-31-2011, 09:49 AM
  7. multiply a number by percentages and round so that they add upto the total %
    By dittotharappel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-19-2009, 01:26 PM

Tags for this Thread

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