Complicated Nested If/Then Statement (I think)

[SGFrank]

This is what I'm trying to do ---- but just can't seem to get it right. Can anyone help???

IF J3="RD" and K3="RA", OR
K3="RD" and L3="RA", OR
L3="RD" and M3="RA", OR
M3="RD" and N3="RA",
if one of the above is true then V3*W3
if none of the above are true then "n/a"

[zbor]

Try this:

Please Login or Register  to view this content.

[SGFrank]

Thank you so much zbor -- I have the same formula needed for a second group of cells (see below). I thought I would just be able to replace the cell references, but that does not seem to work. I hate to ask, but can you tell me what I'm doing wrong?

What I need for the next grouping:
IF N3="RD" and O3="RA", OR
O3="RD" and P3="RA", OR
P3="RD" and Q3="RA", OR
Q3="RD" and R3="RA",
if one of the above is true then V3*W3
if none of the above are true then "n/a"

I changed your formula to: =IF(SUMPRODUCT(--(N3:R3="RD"),--(N3:R3="RA")), V3*W3, NA())

Thanks in advance to any insight you can offer!

[SGFrank]

Drat -- this is how flustered I am about this. Sorry if I sent this already, but I was interrupted, and now I'm not sure if my response went out.
I figured out my mistake in re the formula. Thank you again for your help though!