Nesting IF/AND's

[amphinomos]

Hi,

I've got this formula working :

=IF(AND(R2="ORANGE",AD2="APPLE"),AD2,CONCATENATE(R2,S2,T2,U2,V2,W2,X2,Y2,Z2,AA2,AB2,AC2,AD2))

and I'd like to nest another IF/AND but I can't quite figure out what I'm doing wrong:

=IF(IF(AND(R2="ORANGE",AD2="APPLE"),AD2,AND(V2="BANANA",X2="CHERRY"),V2,CONCATENATE(R2,S2,T2,U2,V2,W2,X2,Y2,Z2,AA2,AB2,AC2,AD2)))

Any help would be great!

Thanks
amphinomos

[Richard Buttrey]

Maybe

=IF(AND(R2="ORANGE",AD2="APPLE"),AD2,IF(AND(V2="BANANA",X2="CHERRY"),V2,CONCATENATE(R2,S2,T2,U2,V2,W2,X2,Y2,Z2,AA2,AB2,AC2,AD2)))

[Olly]

Try:

=IF(AND(R2="ORANGE",AD2="APPLE"),AD2,IF(AND(V2="BANANA",X2="CHERRY"),V2,CONCATENATE(R2,S2,T2,U2,V2,W2,X2,Y2,Z2,AA2,AB2,AC2,AD2)))

[amphinomos]

So obvious it hurts...thanks guys