In Excel, how do you add percentages for example
RETAIL PRICE = WHOLESALE PRICE+50%OF THE WHOLESALE PRICE?
2007-01-10 10:07:22 · 5 answers · asked by yamahaqi 3 in Computers & Internet ➔ Software
assuming that "WHOLESALE PRICE" = A1
and "RETAIL PRICE" = B1
in B1 cell type:
=A1*1.5
2007-01-10 10:44:01 · answer #1 · answered by ZOTheGOn 3 · 1⤊ 0⤋
The simplest method would probably be to have Retail Price = Wholesale Price * 1.5
2007-01-13 14:53:58 · answer #2 · answered by Robert H 1 · 0⤊ 0⤋
The previous two answers are correct, but are you sure that you want to add 50% of the wholesale price? That gives you a 33.33% gross margin, since 100% is two thirds of 150%, and the difference is one third.
2007-01-11 13:20:48 · answer #3 · answered by nospamcwt 5 · 0⤊ 0⤋
____________ A ____________ B __________________ C
1 Percent:_______________ 0.50
2 Wholesale: _____________ 12
3 Retail: ____________ =B2 + B2*$B$1
4
Now you can create Wholesale prices in row 2 and copy (from B3) and past (in row 3) Retail prices.
(Note: the "$" for "$B$1 hold the offset relative for when you copy/paste).
2007-01-10 18:37:44 · answer #4 · answered by Ware 2 · 0⤊ 0⤋
Easy..... : =WHOLESALEPRICE+(.05*WHOLESALEPRICE)
Put that into the formula space and that will give you RETAILPRICE
2007-01-10 18:36:28 · answer #5 · answered by CRA 3 · 0⤊ 1⤋