multiple if's question

[k3rnunn05]

im trying to make a formula that will do this

if i put in the name "joe snuffy" it returns 220
if i put in the name "gilligan snuffy" it returns 350
if the cell is blank it returns 0
if any other name is put in the cell it returns 40

 

[texasalynn]

try this
=IF(A1="joe snuffy",220,IF(A1="gilligan snuffy",250,IF(A1="",0,40)))

 

[Jonmo1]

Welcome to the board...

make a table on your sheet somwhere with your list of names and their respective values.
For example
column F = Names
column G = Respective Values

Then you can use this formula...where A1 is the cell you're testing..

=IF(A1="",0,IF(ISNUMBER(MATCH(A1,F:F,0)),VLOOKUP(A1,F:G,2,FALSE),40))

 

[k3rnunn05]

wow that was quick.. thanks much you guys are the best!