Check to see if there is a value in two different cells

[kkwill]

I am trying to figure out if it is possible to check two cells to determine if there is a value in both cells vs a value in only one of the cells. Is there a function for this?

Something like this:

Column 1	Column 2	Is there a value in both cells?
6	18	Yes
20		No
	180	No
33	19	Yes

 

[Joe4]

Lots of different ways, i.e. to check cells A2 and B2:

=IF(COUNTA(A2:B2)=2,"Yes","No")

That will count the cell if ANYTHING is in it.

If you only want to count it if the entry is a number, use this instead:

=IF(COUNT(A2:B2)=2,"Yes","No")