IF function

Hi,

I have searched for about an hour, but I do not know enough to search for the proper tutorial. Anyways, I need a function to add lets say cells B2&C2, but if B2 = "DNI" then the output be C2. If C2="DNI" then the output B2. If both say DNI then the output "DNI".

Can anyone help?

This is what I have came up with so far. (This is after about 1/2 hour of tutorials haha.)

=IF(AND(B9="DNI",C9="DNI"),"DNI",B9+C9)

*The problem is this only helps me if both cells read DNI. If only one reads DNI and the other is a number I would receive incorrect information.

Either of these approaches will work:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Does that help?

OOps! I co-mingled two responses...this is edited to correct that:
COUNTIF returns the count of cells that contain a pattern...in this case: equals "DNI".
So, if both cells contain DNI, the count = 2