Profit margin formula

HI OTT62,

"What I am looking for is to be able to set my margins at say, 30% then the sale price is then automatically set after selecting a 30% margin. Is that possible?"

SG provided the formula to do exactly that in the FIRST reply to your question. (That reply should be marked "solved")

Here's a table showing the results for a variety of Margin settings, Your 910 example is highlighted, as is 30%, 50%, 75% and 100% (impossible to achieve unless your cost was zero, and even then impossible to calculate due to division by zero).

I've included a chart showing all of the percentage margin results from 1 to 99 in one percent steps.

Your syntax error may have resulted from including the = sign at the beginning when entering the formula.

Select the cell, tap = to open the Formula Editor, enter all of the formula, NOT including the opening =, click the green checkmark to confirm the formula.

Regards,

Barry

OTT62 wrote:

How would I just add 30% to my cost price for example?

Thanks for your help.

That would give you less than a 30% profit margin (since profit margins are calculated on the sales price). It's more like a "markup." It's easy to do.

If your cost is in A2 and 30% is in B2, then you could simply enter =A2*(1+B2) in the cell where you want the sales price to appear. Or if you want the markup to be in the formula itself you can enter =A2*(1+0.30).

SG

Use / to enter the division symbol, and * to enter multiplication in the formula editor. These will be displayed as ÷ and × , similar to what you would see on a calculator.

So you would enter the formula as:

A2/(1−B2).

But it will be displayed as:

A2÷(1−B2)

SG

OTT62 wrote:

as it came up with a syntax error! Whatever that is.

If you copy paste the formula you've used into a post here, perhaps we can sort that out. Double-click to open the formula editor, selecting everything in it, command-c to copy, click in a post here, command-v to paste.

SG

So cost is in B2. And you say 910 is in D2. Where is the 77%. Where do you have your formula?

I suggest setting up the exact same example as I posted first to see if you get 100 as your sale price.

SG

I don't know of any course. Have a look at Help > Numbers Help and Formulas & Functions Help in your menu. Also study templates at File > New in your menu. You can also find some applicable items on YouTube (though some refer to an old version and may be a little confusing).

Most (but not all) of the functions in Numbers work the same way in Excel (and in Excel clones). So if you can't figure out how a function works in Numbers you can also do a search for the formula and Excel. That way you may find more explanations and examples.

SG

You can do something like this:

If cost is in A2, desired margin (in %) is in B2, then enter:

=A2/(1−B2)

SG

Did you find the suggestions helpful? Anything more we can do here?

SG