if statment with more than 7 logical values

[kings21]

I tried using this based on another post

=(IF(C5="Jim",H5*27.5,IF(C5="Don",H5*29,IF(C5="Francisco",H5*25.5,IF(C5="Cristobal",H5*16,IF(C5="Paulino",H5*19,IF(C5="Alex",H5*19,IF(C5="","",)))))))&IF(C5="Joe",H5*15,IF(C5="Martin",H5*28.5,IF(C5="Ernesto",H5*16,IF(C5="","")))))


but keep getting this as an example

159.5FALSE

I am sure I just missed something small somewhere in there.

Thanks in advance!!

 

[Andrew Poulsom]

Use a lookup table:

Excel 2010

	A	B	C	D	E	F	G	H
1	Jim	27.5
2	Don	29
3	Francisco	25.5
4	Cristobal	16
5	Paulino	19	Jim	2750				100
6	Alex	19
7	Joe	15
8	Martin	28.5
9	Ernesto	16

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

The formula in D5 is:

=IF(C5="","",H5*VLOOKUP(C5,A1:B9,2,FALSE))

 

[Domski]

Hi,

Try:

=IF(C5="Jim",H5*27.5,IF(C5="Don",H5*29,IF(C5="Francisco",H5*25.5,IF(C5="Cristobal",H5*16,IF(C5="Paulino",H5*19,IF(C5="Alex",H5*19,IF(C5="","",)))))))&IF(C5="Joe",H5*15,IF(C5="Martin",H5*28.5,IF(C5="Ernesto",H5*16,"")))

I would use a lookup table though as Andrew suggests.

Dom

 

[kings21]

Thanks to both of you!! I think Dom’s will work easier for the sheets I need to use it for and because I really don't know much about using a lookup table.

 

[kings21]

Ohh one more quick question. I lost the formatting using Dom's formula. How do II get it back to currency?

 

[kings21]

Nevermind figured it out!! Thanks again for al lyour help!!!

 

[Andrew Poulsom]

Thanks to both of you!! I think Dom’s will work easier for the sheets I need to use it for and because I really don't know much about using a lookup table.

You should really take the time and trouble to learn lookups, as it will reward you in the future. It's not difficult and here's a tutorial:

Excel VLookup Function Examples

 

[Andrew Poulsom]

Thanks to both of you!! I think Dom’s will work easier for the sheets I need to use it for and because I really don't know much about using a lookup table.

You should really take the time and trouble to learn lookups, as it will reward you in the future. It's not difficult and here's a tutorial:

Excel VLookup Function Examples