three nested If statements

[DNapoli]

Can someone help me get this to work. Currently becasue I added the last if statement it does not work.

Thanks!
Danielle

=IF(G2="FDIC","FDIC",IF(ISNUMBER(SEARCH("*GSK*",H2)),"GSK",M2)), IF(ISNUMBER(SEARCH("*DCM*",J2)),"DCM",M2)

 

[DNapoli]

I actually got it to work my Self ..Yea for me!!

=IF(G223="FDIC","FDIC",IF(ISNUMBER(SEARCH("*GSK*",H223)),"GSK",IF(ISNUMBER(SEARCH("*DCM*",J223)),"DCM",M223)))

 

[Soggy]

You need to tell us what you are trying to do.

This won't work as the first if statement leads to the next if statement if it is false and post FDIC if true.

The second if statement will get the value from M2 if false and post GSK if true.

The third if statement is not nested in either so is creating an error.

If you want it to go to third if statement on a false result then hopefully this will work

=IF(G2="FDIC","FDIC",IF(ISNUMBER(SEARCH("*GSK*",H2)),"GSK",IF(ISNUMBER(SEARCH("*DCM*",J2)),"DCM",M2)))

All you needed was to replace the M2 in you second statement wiht the third if statement and add the brackets on.

If you were after something else let us know.

Don't think I have ever typed statement so much in my life.