# markup percentage

1. ## markup percentage

what formula do i use to markup a percentage so my balance is the same after discount
for example
a=amount not to be discounted ie marked up
b=amount to be discounted
c= total of a+b before discount
d=discount percentage
e=balance after discounted

winston

2. ## Re: markup percentage

Something like this?

3. ## Re: markup percentage

See attached:

A2: original amount (10)
B2: mark up amount (2)
C2: Total A1 + B1
D2: Discount % =B2/A2
E2: Balance =A2*D2+A2

E2 amount, after discount %, will equal sum of A2:B2

4. ## Re: markup percentage

the markup is a percentage to allow for percentage discounted so i think i still do not have correct answer.

sorry if i am not explaining myself, i am finding this very difficult to solve none of my friends seem to know how to do this.

winston

5. ## Re: markup percentage

the markup is a percentage to allow for percentage discounted so i think i still do not have correct answer.
Your initial post describes this as an amount not a percentage. Now you've changed the requirement.

sorry if i am not explaining myself, i am finding this very difficult to solve none of my friends seem to know how to do this.
Upload an example workbook that manually shows exactly what you want to achieve and has the structure of your real workbook.

6. ## Re: markup percentage

hi,

i am sorted, asked friend who knows the answer is use alot in costings.

thanks for the time sorry you could not understand my question

wob

7. ## Re: markup percentage

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