Member Avatar for ArtChess

How do you do 90 cents divided by .70 to give a mark up on a spread sheet.

Thanks in advance

  • 2 Contributors
  • 3 Replies
  • 167 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by hollystyles
Member Avatar for hollystyles

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)
Member Avatar for ArtChess

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.

Member Avatar for hollystyles

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.