Excel if or statements

[domobrien]

I've got 3 IF statements that I'm trying to combine:
=IF(AND(D57="Yes",D58="No"),F55,0)

=IF(AND(D57="No",D58="Yes"),G55,0)

=IF(AND(D57="Yes",D58="Yes"),H55,0)

I can't work out the OR syntax. any help appreciated!

 

[Joesif]

Try this

=IF(CONCATENATE(D57,D58)="YESNO",F55,0)+IF(CONCATENATE(D57,D58)="NOYES",G55,0)+IF(CONCATENATE(D57,D58)="YESYES",H55,0)

Regards
Joe

 

[domobrien]

Works a treat. Thanks!

 

[lenze]

What do you do for "No" "No" ??

=IF(D57="Yes",IF(D58="Yes",H55,F55),IF(D57="Yes",G55,"N/A"))

lenze

 

[Joesif]

NO NO would result in 0

But if you wanted it to show N/A


=IF(CONCATENATE(D57,D58)="NONO","N/A",(IF(CONCATENATE(D57,D58)="YESNO",F55,0)+IF(CONCATENATE(D57,D58)="NOYES",G55,0)+IF(CONCATENATE(D57,D58)="YESYES",H55,0)))

Joe