Multiple if/and function

[flozza27]

Hi all I cant work out why the follwing is not working its probably something stupid it seems to fall over when it gets to the second or third if.
=IF(A16=B16,"Good",IF(AND(B16=F16,H16=I16,"Good"),IF(AND(B16=G16,H16=J16,"Good"),"#N/A")))
any help much appreciated

 

[gallan]

I think you have a couple of ) out of place

Try

=IF(A16=B16,"Good",IF(AND(B16=F16,H16=I16),"Good",IF(AND(B16=G16,H16=J16),"Good","#N/A")))