+ Reply to Thread
Results 1 to 4 of 4

I don't understand multiple IF / THEN Excel Formula

  1. #1
    Registered User
    Join Date
    05-13-2012
    Location
    Daytona Beach, FL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question I don't understand multiple IF / THEN Excel Formula

    Hi there,

    I looked at the "multiple IF" post by Paul earlier today in this sub-forum, but I don't understand it.

    I've written many formulas before for a spreadsheet, but nothing as detailed as the one I'm trying to write now. Please see the attached worksheet and if you have any more questions, please let me know...and thanks for your help!

    The Formula I am trying to write is the example below -
    If B3 is the name JAKE, then C3 is 16.63; If B3 is the name JARED then C3 is 17.78;
    If B3 is the name KEITH, then C3 is 14.40; If B3 is the name MATT, then C3 is 14.40;
    If B3 is the name SANDY, then C3 is 14.40; If B3 is the name TIM then C3 is 25.00;
    so on and so forth, all the way down the B & C columns.

    The list of names and their rates are on sheet 2. I want to type the name in B and I would like C to auto-fill, type the hours in D and E
    would also auto-fill. The way it is written now, if I change the name (i.e. from MATT to JAKE) the wrong rate is in column C.

    Do I need to do an "array", I don't know much about them. I need to implement this formula at work in the next few days.

    P.S. I use Excel 2003 at home and Excel 2007 at work, if that makes a difference in the written formulas.
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,515

    Re: I don't understand multiple IF / THEN Excel Formula

    Hi

    instead of lookup try
    Please Login or Register  to view this content.
    and pull down as needed
    I'm a newbie with PQ, so if my solution can be improved, please let me know. Thanks

  3. #3
    Registered User
    Join Date
    05-13-2012
    Location
    Daytona Beach, FL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: I don't understand multiple IF / THEN Excel Formula

    Pepe,

    Thanks soooo much...it worked!!!
    Now I'm going to try to figure out a formula for the time input. That one shouldn't be as hard.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,515

    Re: I don't understand multiple IF / THEN Excel Formula

    If you have some time try also to make out why LOOKUP didn't work ( in your case )

+ 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