How do you do 90 cents divided by .70 to give a mark up on a spread sheet.
Thanks in advance
ArtChess
0
Junior Poster in Training
Recommended Answers
Jump to Posttaking you literally
=SUM(90/0.7)But I'm not sure that's what you mean.
Normally you want to add 7% markup to an existing price ?
=SUM(90*1.07)
All 3 Replies
hollystyles
113
Veteran Poster
taking you literally
=SUM(90/0.7)But I'm not sure that's what you mean.
Normally you want to add 7% markup to an existing price ?
=SUM(90*1.07)
ArtChess
0
Junior Poster in Training
How do you do 90 cents divided by .70 to give a mark up on a spread sheet.
Thanks in advance
ok never mind i figured it out:
sending email with attach file of example on how this can be done. Formula is
=SUM(D11*(1+D12))
Where D11 has the data of unit price and
D12 has the data of percentage markup.
hollystyles
113
Veteran Poster
yeah I figured that's what you really meant.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.