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

1. ## 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.

2. ## 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

3. ## 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. ## 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 )

##### 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1