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
Something like this?
See attached:
row 1 = headings
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
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
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
Your initial post describes this as an amount not a percentage. Now you've changed the requirement.the markup is a percentage to allow for percentage discounted so i think i still do not have correct answer.
Upload an example workbook that manually shows exactly what you want to achieve and has the structure of your real workbook.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.
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
Please post your solution so that others who find this thread will have an answer to a similar problem. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks