Variable percentage increases.

[Oymonkey]

Hello,

First time posting, so be gentle!

This is probably a really easy solve for someone, but I can't explain it properly when I search for a solution.

Basically,

I am working on a large RRP price file which I need to create a formula where if our profit is below a certain amount then I want the formula to increase the price by a certain percentage to reach the required profit. Not sure if that makes sense (it kind of does in my head!)

Thank you in advance.

Matt

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

[Oymonkey]

Hello,

Thank you for the reply.

Please find attached a small sample

So where D is Less than £5, I need the formula to work out what percentage to increase C to make D £5

Make sense??

Thank you

Matt

[Glenn Kennedy]

To calculate the required selling proce:
=B2+MAX(5,C2-B2)

And if you really want to calculate the % increase over col C:
=(B2+MAX(5,C2-B2)-C2)/C2
formatted as %