Morning all,
As per title, I am trying to compare a column of text cells which contain "Yes" or are empty and a columns of numbers. If they are "Yes" and "1" on the same row, I want to output an "OK" message.
Excel seems happy with the following code but it does not work and returns an empty cell if the two conditions are true.
=IF(AA6="yes"& AR6="1","OK","")
How does that look?