Nested IF Statements Returning "FALSE" Value

[Brandon39]

Hey all,
I am using a combination of nested IF statements and VLOOKUPs to get a vlue to appear in a specific cell.

The IF statements check to see if a specific text value displays in a specified cell and then uses a VLOOKUP to match the value to that text if true. If it is false it moves on to check the next specific text value. There are 5 different text values it needs to check.

I have gotten my formula to the point where it can match all the text values appropriately with the VLOOKUPs, however I can't seem to close out the formula should NONE of the text value's be true. When this happens the cell returns a value of "FALSE". I would like to be able to avoid this and have a number value displayed.

 

[crook_101]

Hi,

Care to post your formula so we can give advice or you may just get a generic response such as "iserror" or "isnumber"

Regards,
Ian

 

[Brandon39]

=IF($N$3="Hit",(ROUND(VLOOKUP($C$3,HELMLOOKUP,5,FALSE)*0.6,0)),IF($O$3="Hit",IF(N3="Spirit",ROUND(VLOOKUP($C$3,HELMLOOKUP,4,FALSE)*0.4,0),IF($N$3="Mastery",(ROUND(VLOOKUP($C$3,HELMLOOKUP,8,FALSE)*0.4,0)),IF($N$3="Crit",(ROUND(VLOOKUP($C$3,HELMLOOKUP,6,FALSE)*0.4,0)),IF($N$3="Haste",(ROUND(VLOOKUP($C$3,HELMLOOKUP,7,FALSE)*0.4,0))))))))

The posted formula is functional in its current state, however all I really need at this point is a way to tell it if none of these checks return TRUE for it to display another VLOOKUP value instead of FALSE.