Formula Help for MS Excel needed
Results 1 to 2 of 2

Thread: Formula Help for MS Excel needed

  1. #1
    Join Date
    Dec 2005
    Posts
    181

    Formula Help for MS Excel needed

    Need help with an Excel formula

    I am trying to make a sheet for recording my shift timings and credit points earned for each shift. So the idea is that suppose Cell B3 to B30 contain my duty shifts
    timings in text form like 0900-1700 or 1600-0000 or 1800-0200 etc etc. Now I want that the next cell like Cell C3 should pick up predetermined values based on the limited categories of data entered in B3. Lets say if B3 contains 0900-1700 then C3 should automatically input 2.00 in C3, If B3 contains 1800-0200 then C3 should automatically change value to 2.58 and so on and so forth.
    What would be the formula for this type of arrangement. Thanks

  2. #2
    Join Date
    Feb 2000
    Location
    Idaho Falls, Idaho, USA
    Posts
    18,063
    Can the results be calculated from the data in the B row cells? If no, then you need a table somewhere in your workbook that has the B row values and the corresponding values that you want in the C row. You can then use a table lookup function to populate the C row values.

    Possibly useful links:

    https://support.microsoft.com/en-us/...an-excel-table

    https://www.youtube.com/watch?v=Dtgh8CKqjdw

    https://www.techonthenet.com/excel/f.../2d_lookup.php

    https://www.techonthenet.com/excel/formulas/lookup.php

    http://www.mbaexcel.com/excel/tutori...ormula-to-use/

Thread Information

Users Browsing this Thread

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

Posting Permissions

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