Need help

M

Moe

How do I get to this function for excel to give me C1
List Price Retail price = $17.99 * 20% = new list price
$12.99 $29.99 = $20.00
A1 B1 C1
 
R

Roger Govier

Hi Moe

Not exactly clear what you are after here.
If you multiply 17.99 * 20% you get 3.60
If you want to increase 17.99 by 20% then the formula is =17.99 *(1+20%)
= 21.59
If you want to decrease 17.99 by 20% then the formula is = 17.99
*(1-20%) = 14.39

If you are saying the Retail price is higher than List price by 20% and
the Retail price is 17.99
then to get the List price it is = 17.99/(1+20%) = 14.99

Can you explain more clearly what you are after, as the values you show
don't seem to match up.
 
J

Joel

don't know what you are really trying to do
$17.99 with 20% markup is $17.99 * 1.2 = $21.58
$17.99 with 20% discount is $17.99 * .8 = $15.99

If you have a list price of $12.99 and want to sell it for $17.99 then your
markup is
17.99/12.99 - 1 = 38% markup

If you selling price is $29.99 and you want to sell it for $20.00 then your
ae selling for20/29.99 = 66.6% of original price (33% mark down).
 
M

Moe

Ok what i want to do is in colum A1 ihave (example $12.99 i want to add 20%
to get a sum amount in dollars).
 
V

vandenberg p

Hello:

In b1 enter: =a1*1.2

Pieter Vandenberg



: Ok what i want to do is in colum A1 ihave (example $12.99 i want to add 20%
: to get a sum amount in dollars).
:>
 
R

Roger Govier

Hi Moe

I would be inclined to enter your percentage by which you want to
uplift, in a separate cell e.g. in cell B1 as 20%
Then your formula is
=A1*(1+B1)

Without touching your formulae, you can change the percentage mark-up at
any time by just altering the percentage figure in B1
 
M

Moe

(example A1 is $29.99 B1 is 20%)
When i use the formula =A1*B1 i get 261900.00%
i want to add 20 percent on A1 and get it in dollars
is there a formula for that

Thank you Again
 
D

David Biddulph

You'd better look at your cell contents and your formula again if you think
that =A1*B1 gives 261900.00% in that situation. It should give 5.998 (or
599.8% if you format the cell as percentage). [Also check that Tools/
Options/ Calculation is set to automatic, not manual.]

If you have 20% in B1 and you want to add 20% to A1, your formula will be
=A1*(1+B1). [Formatting as currency will hopefully give you the answer in
dollars, if your settings recognise dollars as your default currency.]
 
Top