Results 1 to 4 of 4

If cell contains text "Labour" then return value from another cell.

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    If cell contains text "Labour" then return value from another cell.

    Good Day; This is my first post, so please forgive me if I don't quite get my point across right.
    I'm trying to set up a simple formula with column "J"; that whenever I enter labour in column "C"; it gives me a total in column "J". I have tried {=IF(C6="Labour",G6+H6,) } or {=IF(C6="Labour",I6,,) with no luck.
    I would like the labour cell to show either the sub total or add G6 and H6. But I just can't make it work.
    Any Useful suggestions?
    Thanks for taking the time consider this.



    ----------A-----------B---------------- C-----------------D-----------------------E---------------------F----------G--------------H------------I-----------J-------------K------------------L

    1]-----Date-------Source---------Description--------Unit Price----------------QTY---------------Taxed------Net Price-------Tax-------Sub-Total--Labour------10% markup-------Total
    2]
    3] 26-Jul-18----Hardware--------Holder-------------$15.00-------------------1------------------------------$15.00---------$----------$15.00----$--------------$1.50------------$16.50
    4] 26-Jul-18----Services---------1 Litre Oil----------$10.00-------------------1--------------------x---------$10.00---------$1.30-----$11.30----$--------------$4.18------------$45.99
    5] 26-Jul-18----Compressor-----Misc. Brass--------$22.94--------------------1--------------------x---------$22.94---------$2.98-----$25.92----$--------------$2.59------------$28.51
    6] 28-Jul-18-----Labour----------Labour-------------$25.75-------------------4.75-----------------x---------$122.31--------$3.35-----$125.66--$125.66------$0.00------------$125.66
    Last edited by Channels; 08-01-2018 at 09:59 PM. Reason: Not aligning right

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 06-11-2017, 02:03 PM
  2. [SOLVED] Formula to Locate Matching Data in Worksheets and return "1" or "0" to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-30-2015, 04:52 AM
  3. Replies: 1
    Last Post: 10-08-2014, 05:56 AM
  4. Replies: 4
    Last Post: 10-05-2013, 10:11 AM
  5. If cell X matches a value in a cell range, return "specific text" - HELP :(
    By paulandrewlee in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-02-2013, 07:06 PM
  6. Replies: 10
    Last Post: 06-10-2012, 03:55 PM
  7. Replies: 2
    Last Post: 08-21-2006, 11:55 AM

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