Function to calculate a markup

[swaink]

Hi All I have a formula that I wish to convert to a function for other users to be able to use. The formula calculates what percentage markup is required to acheive a stated percentage profit. it would look something like
"markup = cost / (100 - profit) * profit"

Any ideads many thanks

Kevin
This message was edited by swaink on 2002-02-20 03:47

 

[pbloem]

Yes please help me, my question are the same as Kevin's.

Regards,

Pete

On 2002-02-20 02:19, swaink wrote:
Hi All I have a formula that I wish to convert to a function for other users to be able to use. The formula calculates what percentage markup is required to acheive a stated percentage profit. it would look something like
"markup = cost / (100 - profit) * profit"

Any ideads many thanks

Kevin
This message was edited by swaink on 2002-02-20 03:47

 

[gvanbee]

=1 + a1/(1-a1)

where a1 = % profit (e.g. 0.33 in a1 for 33% profit) yields 1.5 for a markup
This message was edited by gvanbee on 2002-08-05 12:27

 

[duplinguy]

If you want a 25% margin and Cost is $1.
If cell A1 contains 1. Formula in B1 is =A1/(1-.25). You'll get 1.3333 (which is your selling price).

 

[pbloem]

Thanks guys, this works great hope I can be of help someday. Cheers