+ Reply to Thread
Results 1 to 3 of 3

automatically calculate price

  1. #1
    Registered User
    Join Date
    12-13-2007
    Posts
    2

    automatically calculate price

    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 in a separate cell. 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.

  2. #2
    Registered User
    Join Date
    10-04-2007
    Posts
    32
    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 in a separate cell. Can anyone help me with this formula?
    Can you clarify this a bit more? Your cost goes up as you increase the amount of tires? So lets say you have 1 tire the cost is $50....when you sell two its now what per for the cost?

  3. #3
    Registered User
    Join Date
    12-13-2007
    Posts
    2

    Got it finally

    Thanks for your offer of help. Once I got the brain back working I worked the formulas out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1