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.
Bookmarks