# Mark up formula

1. ## Mark up formula

i need help with this problem if anyone is kind enough to assist me

i have a project and i am making a spreadsheet for a make believe green grocers. i have a retail price and a whole sale price

to work out the retail price i need to sue this forumula

retail price = wholesaleprice + x% of wholesale price

im stuck, what i have done is declared the percent value on the page, which can be changed at any time, how do i then substitue this value in to the formula (and most importantly, what is the formula!!!)

thanks peeps, probs a really easy question but i am new to this :p

2. something like:

=A1+A1*B1

where A1 houses wholesale price and B1 house percentage (represented as percent)

3. A1 = wholesale price
B1 = 10%
C1 =A1+(A1*B1)

4. when i declare my variable (x) do i have to declare it as just an integer or as a percent i.e

mark up = 10
mark up = 10%

5. As a percentage - try 10%

6. also i dont think that the forumal works as when i declare the mark up as 20% and wholesale as 20 and use your formula the retail comnes out as 2400%?

7. You would either change the format of your percent cell to Percent or you incorporate the percentage in the formula...

e.g. =X1+Y1*X1%

8. Format A1 - General
Format B1 - Percentage
Format C1 - General

9. Originally Posted by oldchippy
Format A1 - General
Format B1 - Percentage
Format C1 - General
i have done that and it coems up with 2400% still

10. Try this one

11. wow thanks peeps, that really helped me out, nice one

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1