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

1. ## 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. ## 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:
`Please Login or Register  to view this content.`
- Moo

Thank You.

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

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

#### 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