IF function

[joenicky]

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.