Thanks:  0
Likes:  0

# Thread: Function to calculate a markup

1. 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 ]

2. 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 ]

3. =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 ]

4. 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).

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•