+ Reply to Thread
Results 1 to 23 of 23

calculating cost

Hybrid View

  1. #1
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: calculating cost

    I meant: can you put in words what the calculation needs to be? Before you can start thinking about formulas, you should have an idea of what you want to do. Do you need to look up data or compare data? Sum, average, whatever? If you sepecify the logic, someone here can give you the formula and/structure translated into Excel. But you need to be able to describe the steps that lead to the result. If not in Excel terms, then in plain words.

  2. #2
    Registered User
    Join Date
    04-09-2010
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: calculating cost

    Quote Originally Posted by teylyn View Post
    I meant: can you put in words what the calculation needs to be? Before you can start thinking about formulas, you should have an idea of what you want to do. Do you need to look up data or compare data? Sum, average, whatever? If you sepecify the logic, someone here can give you the formula and/structure translated into Excel. But you need to be able to describe the steps that lead to the result. If not in Excel terms, then in plain words.

    Ahk..

    Well ill need to lookup data therefore, VLOOKUP
    Also need to use IF statement to calculate duration (already worked that 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