As title says i have been racking my brains for the last hour trying to figure this out and have finally given in and decided to ask on here.
Basically if i have a price say £100 and i have a customer that normally gets a 20% discount, So the customer would only pay £80.
I need to lower the price by 14% so the new price is £86 but i still need the customer to be paying £80... what would the formula be to work out the customers new %?
I hope that made sense and thanks in advance!
Are you tring to figure out how to calculate what percentage of 86 is 80?
Sorry my explenation wasn't great, with the example i gave the new customer discount would be 6.98%
So on the new product price of £86 the customer will still be paying £80 with the new 6.98% discount.
It's the new Customer discount % i need the formula to work out.
Hope that clears it up.
Hi and welcome to the board. Unfortunately,
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks