# 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  Register To Reply

2. ## Re: markup percentage

Something like this?  Register To Reply

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  Register To Reply

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   Register To Reply

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.  Register To Reply

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   Register To Reply

7. ## Re: markup percentage

Please post your solution so that others who find this thread will have an answer to a similar problem. Thanks.   Register To Reply