Calculating if 1 for 2 criteria are true
 

I am wanting to add c2 to d2 if either a2 or b2 are equal to e1.

I am having a mind blank. How do I do this?

Calculating if 1 for 2 criteria are true
 

=IF(OR(A2=1,B2=1),Sum(C2:D2),"")

Should do it mate?

"The Rook" wrote in message
...
I am wanting to add c2 to d2 if either a2 or b2 are equal to e1.

I am having a mind blank. How do I do this?

Calculating if 1 for 2 criteria are true
 

Hi

=IF(OR(A2=E1,B2=E1),C2+D2,"")

--
Regards
Roger Govier

"The Rook" wrote in message
...
I am wanting to add c2 to d2 if either a2 or b2 are equal to e1.

I am having a mind blank. How do I do this?

Calculating if 1 for 2 criteria are true
 

Try

=IF(OR(A2=E1,B2=E1),C2+D2,"")

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis





"The Rook" wrote:

I am wanting to add c2 to d2 if either a2 or b2 are equal to e1.

I am having a mind blank. How do I do this?