Formula or VBA to increase a cell value based off another cell.

[Flexi1]

Hi

I need some help and I hope I am explaining this correctly, I have attached a photo of my spreadsheet and I need
to increase the value of column (M) so that each value has a minimum profit of 2.50

Column (M) is determined by column (I) so I need something that will adjust column (I) until the value
in column (M) reaches 2.50.

Any figures in column (M) that are above 2.50 need to be skipped as they are already good.

Basically I need the sale price in column (I) to increase so that the profit is a min of 2.50 on all items that currently fall below that amount, the full spreadsheet has 100,00 rows
( Column (I) and (M) have formulas already applied to get their totals, not sure if that matters)

 

[Joe4]

Sorry I see what has happened there, I was meant to remove the formula for that column when I created the spreadsheet to upload here, looks like I forgot. The figure in (I) isn't meant to have the formula in there.

But don't columns G and H need to add up to column I?
If that is the case, then it is probably column G or H that need to be updated.
But which one?

 

[Flexi1]

But don't columns G and H need to add up to column I?
If that is the case, then it is probably column G or H that need to be updated.
But which one?

It would be the markup that would need changing, the markup dictates the sale price. The purchase price plus the markup equals the sale price.

 

[Flexi1]

My 2 cents, I would add some columns so you can have some flexibility on the Target Profit (My column O). If you are happy with the results in P, then you can copy that column and Paste Special - Values back into I. And I threw in some conditional formatting on the Profit column so you can see which ones fall below the target. This method lets you preview the changes that will be made before you replace the existing data.
(I had created the data and formulas from your first picture so my column headings are messed up. I changed data in G and H to test different results.)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1									price				profit		Target Profit	Updated Sale Price	Updated Profit
2	7620B	7620BBLAC1112	instock	6.35	1.27	3.69	7.62	12	19.62	2.94	2.943	3.924	2.19		2.50	19.93	2.50
3	7620B	qwerty	instock	6.35	1.27	3.69	7.62	13	20.62	2.94	2.943	3.924	3.19			20.62	3.19
4	7620B	asdfgh	instock	6.35	1.27	3.69	8	10	18.00	2.94	2.943	3.924	0.19			20.31	2.50
Sheet1

Cell Formulas
Range	Formula
P2:P4	P2	=IF(M2<$O$2,($O$2-M2)+I2,I2)
Q2:Q4	Q2	=P2-L2-K2-J2-G2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M2:M4	Expression	=M2<$O$2	text	NO

Hi, thanks for this, the problem I get is that when I input the new sale price, as the prices increase so do the costs so then the profit falls below the threshold of 2.5 again

 

[Joe4]

If you put this formula in cell H2, it seems to return the desired value of 2.50 in cell M2:

=G2+5