# Multiple if/and function

#### flozza27

##### New Member
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

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### gallan

##### Board Regular
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")))

Replies
1
Views
99
Replies
1
Views
103
Replies
4
Views
170
Replies
5
Views
264
Replies
0
Views
235

1,181,409
Messages
5,929,771
Members
436,688
Latest member
sunnyBNH013

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back