Calculating if 1 for 2 criteria are true

  • Thread starter Thread starter The Rook
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF using 2 cells that equal each other 1
Merged cells 1
Comparing 2 cells using vlookup 4
Segregating Duplicate Transactions 3
Excel 2007 SP2 Addition of Negative Numbers Error 7
VLOOKUP problem 3
Calculating elapsed days and hours 4
Help on an if then statement! 6

Back
Top