navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Any Excel Users Available?

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Community >> Computer Software and Hardware issues >> Any Excel Users Available?
Page: [1]
 
MCD

 

Posts: 635
Joined: 3/19/2002
From: Al USA
Status: offline

 
Any Excel Users Available? - 12/13/2007 17:07:59   
I sell tires and I'm having a hard time setting up a spreadsheet that will do what I need done.

The cost of 1 tire of X brand my formula is easy. It is =SUM(F2+25). F2 is my cost and 25 is my profit.

If I sell two tires I want the formula to add my cost + 79.00 + 2.00 for each 1.00 increase in my cost. Can anyone help me with this formula?

Hopefully I will soon be able to change the cost in my spreadsheet and the price for both 1 and 2 tires will automatically calculate themselves. Any help is appreciated.

_____________________________

Author of " How To Build A Website With Duct Tape"
bobby

 

Posts: 11394
Joined: 8/15/1969
From: Seattle WA USA
Status: offline

 
RE: Any Excel Users Available? - 12/14/2007 0:31:14   
add a third column for Quantity, then add a multiplier to the formula?


_____________________________

If con is the opposite of pro, is Congress the opposite of progress?


:)

(in reply to MCD)
MCD

 

Posts: 635
Joined: 3/19/2002
From: Al USA
Status: offline

 
RE: Any Excel Users Available? - 12/14/2007 6:04:09   
Thanks Bobby. This formula became very easy once my brain started working again. Your help is appreciated.

_____________________________

Author of " How To Build A Website With Duct Tape"

(in reply to bobby)
Page:   [1]

All Forums >> Community >> Computer Software and Hardware issues >> Any Excel Users Available?
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts