Hello, i am stupid when it comes to this stuff and frustrate easily!! If
their is anyone that can help me i would greatly appreciate it. I have a
product and it cost me $4.50 to produce. I would like to mark it up 200%.
What would the function be?? Thanks

To mark up a product by 200%, you need to add 200% of the original cost to the original cost.

Here's how you can do it in Excel:

1. In a cell, enter the original cost of the product, which is $4.50 in your case.
2. In another cell, enter the markup percentage, which is 200% or 2.
3. In a third cell, enter the formula "=original cost*(1+markup percentage)" without the quotes. In this case, it would be "=4.50*(1+2)".
4. Press enter and you will get the result, which is $13.50.

So the formula you need is "=original cost*(1+markup percentage)" where "original cost" is the cell containing the original cost of the product and "markup percentage" is the cell containing the markup percentage.

On Thu, 4 Mar 2010 18:29:01 -0800, StitchWitch
wrote:

Hello, i am stupid when it comes to this stuff and frustrate easily!! If
their is anyone that can help me i would greatly appreciate it. I have a
product and it cost me $4.50 to produce. I would like to mark it up 200%.
What would the function be?? Thanks


100% "mark-up" would be $9.00. 200% mark-up would be $13.50.

Mark-up is an amount added to a cost to arrive at a price.

Percent increase is a bit different. An price that is increased by 25%
would be (4.50 x 0.25) + 4.50 = 5.625

Then you have to decide how you want to round your calculations,
because you can see where certain math creates yet another significant
figure. Round up... round down... but at what point?

100% markup is (original_value x 1) + original_value

So, to review. 100% is your original number multiplied by 1.00 and...

25% is your original number multiplied by 0.25.

One percent is 0.01 times the number (your number).

So the scale is 0.01 through 0.99 as representing 1 percent and 99
percent, respectively. 100% (the scale is really zero to 1) is "One
point O" or 1.00 times the number, so 200 is 2.0 times the number.

If your price is in A1

=A1+(A1*2)

If what you really wanted was 100% markup, yielding a price double the
original, the formula would be:

=A1+(A1*1)

It really is not required for me to parenthesize the second portion,
but I do so to show the process.

As an aside, you could place a number in B1 that represents a markup
percentage between 1 and 100 (any number really), and use this formula in
any other cell (C1)

=A1+(A1*(B1*0.01))

That will give you any markup percentage calculation you want.

On Thu, 4 Mar 2010 18:29:01 -0800, StitchWitch
wrote:

Hello, i am stupid when it comes to this stuff and frustrate easily!! If
their is anyone that can help me i would greatly appreciate it. I have a
product and it cost me $4.50 to produce. I would like to mark it up 200%.
What would the function be?? Thanks



http://www.mediafire.com/?txmjzjjmmmm

=a1+a1*200%

Regards,
Fred

"StitchWitch" wrote in message
...
Hello, i am stupid when it comes to this stuff and frustrate easily!! If
their is anyone that can help me i would greatly appreciate it. I have a
product and it cost me $4.50 to produce. I would like to mark it up 200%.
What would the function be?? Thanks

=A1*3


"StitchWitch" wrote:

Hello, i am stupid when it comes to this stuff and frustrate easily!! If
their is anyone that can help me i would greatly appreciate it. I have a
product and it cost me $4.50 to produce. I would like to mark it up 200%.
What would the function be?? Thanks

On Fri, 5 Mar 2010 06:01:01 -0800, Teethless mama
wrote:

=A1*3


"StitchWitch" wrote:

Hello, i am stupid when it comes to this stuff and frustrate easily!! If
their is anyone that can help me i would greatly appreciate it. I have a
product and it cost me $4.50 to produce. I would like to mark it up 200%.
What would the function be?? Thanks


Well, your nym is right on the money.

On Fri, 5 Mar 2010 06:01:01 -0800, Teethless mama
wrote:

=A1*3


"StitchWitch" wrote:

Hello, i am stupid when it comes to this stuff and frustrate easily!! If
their is anyone that can help me i would greatly appreciate it. I have a
product and it cost me $4.50 to produce. I would like to mark it up 200%.
What would the function be?? Thanks


Times 3 indeed.

http://www.mediafire.com/file/mz4jxq...rkItUpRev3.xls