+ Reply to Thread
Results 1 to 4 of 4

my price is 150% to high so what are they paying

  1. #1
    Registered User
    Join Date
    06-29-2010
    Location
    Wales
    MS-Off Ver
    Excel 2007
    Posts
    21

    my price is 150% to high so what are they paying

    I've got a customer who says for example my price is 150% higher than what they pay now.

    So my price is £250 and they said I was 150% to high as they only pay £100

    If I put in cell A1 £250 and cell B1 £100 and in cell C1 this formula =SUM((A1-B1)/B1) I get 150%

    If a customer had just said to me i was 150% to high when I quoted £250 what would the formula be to work out that the cost was £100 (some customers don't tell me the actual cost just the percentage I'm out by)

    Racking my brains and for somebody I'm sure it'll be simple.

    Many thanks in advance to anybody who is able to help me.

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: my price is 150% to high so what are they paying

    Assume your quoted price is in A1, and the over-percentage is in B1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    - Moo
    Last edited by Moo the Dog; 10-02-2019 at 04:50 PM.

  3. #3
    Registered User
    Join Date
    06-29-2010
    Location
    Wales
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: my price is 150% to high so what are they paying

    Thank You.

  4. #4
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: my price is 150% to high so what are they paying

    Glad to help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 07-29-2019, 09:05 AM
  2. Replies: 11
    Last Post: 08-06-2018, 05:39 AM
  3. Replies: 10
    Last Post: 08-06-2018, 05:33 AM
  4. [SOLVED] Track High Price of Stock from Date of Purchase
    By ecoperson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-07-2013, 02:53 PM
  5. [SOLVED] Define current price as a % based on a high / Low price
    By helpbitte in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-21-2012, 12:45 PM
  6. How do I formulate a high price column
    By Lou New At Excel in forum Excel General
    Replies: 1
    Last Post: 04-17-2006, 08:35 PM
  7. [SOLVED] Recording a high price on a worksheet
    By Lou New At Excel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-16-2006, 11:35 AM

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