# IF statement for price markup

#### bwaaack

##### New Member
Someone please solve this equation. I have a markup equation that I fill down. I'm trying to net no less that 5.00 but I have products with a wide range of total cost.

Price = Total cost + Markup percentage. Net = Price - Total cost. That part works great. The following is what i'm trying to figure out.

If net equals < 5.00 at the original markup, than Markup X% with a max net of 5.00. Only for the net amounts that were under 5.00 at the original markup.

Thank you so much smart people

##### New Member
See if I'm understanding correctly... Columns A and B have numbers typed in. Column B is my standard markup percentage, which is 22% (0.22).

Columnc C / D / E are formulas - here are the row 2 formulas, which are dragged down to other rows:
C2: =A2*(1+B2)
D2: =IF(A2*(1+B2)-A2<5,A2+5,A2*(1+B2))
E2: =(D2-A2)/A2

Column C is our initial price calculation, which we're NOT going to use... it adds our standard markup percentage to the total cost.

Column D is our new price calculation. It uses the standard markup percentage to check if the resulting price difference is smaller than 5: If so, it just adds 5 to the total cost; otherwise it goes with the standard markup percentage.

Column E confirms what exact markup has been applied. With row 2, it had to resort to the minimum markup of 5; whereas on rows 3 and 4 the standard markup percentage was enough to get over the minimum markup amount.

Last edited:

1,078,541
Messages
5,341,061
Members
399,414
Latest member
EMW2159

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...