Question on Excel

Thread Solved

Join Date: Jun 2004
Posts: 90
Reputation: ArtChess is an unknown quantity at this point 
Solved Threads: 0
ArtChess ArtChess is offline Offline
Junior Poster in Training

Question on Excel

 
0
  #1
Aug 23rd, 2006
How do you do 90 cents divided by .70 to give a mark up on a spread sheet.

Thanks in advance
Reply With Quote Quick reply to this message  
Join Date: Feb 2005
Posts: 1,181
Reputation: hollystyles will become famous soon enough hollystyles will become famous soon enough 
Solved Threads: 67
hollystyles's Avatar
hollystyles hollystyles is offline Offline
Veteran Poster

Re: Question on Excel

 
0
  #2
Aug 23rd, 2006
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)
Last edited by hollystyles; Aug 23rd, 2006 at 12:15 pm.
==========================================
Yadda yadda yadda...
Web junky, fevered monkey
Reply With Quote Quick reply to this message  
Join Date: Jun 2004
Posts: 90
Reputation: ArtChess is an unknown quantity at this point 
Solved Threads: 0
ArtChess ArtChess is offline Offline
Junior Poster in Training

Re: Question on Excel

 
0
  #3
Aug 23rd, 2006
Originally Posted by ArtChess View Post
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.
Reply With Quote Quick reply to this message  
Join Date: Feb 2005
Posts: 1,181
Reputation: hollystyles will become famous soon enough hollystyles will become famous soon enough 
Solved Threads: 67
hollystyles's Avatar
hollystyles hollystyles is offline Offline
Veteran Poster

Re: Question on Excel

 
0
  #4
Aug 23rd, 2006
yeah I figured that's what you really meant.
==========================================
Yadda yadda yadda...
Web junky, fevered monkey
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Windows Software Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC