Calculating if 1 for 2 criteria are true

T

The Rook

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?
 
F

francis

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
 
Top