How do I check two conditions?

I used to know how to do this, and now I can’t even find the answer through internet search. Apparently, I’m going senile.

Here’s what I am trying to do.

For each row, I want to create a function in column/cell AJ. The function will check for a specific text value in a cell (current row, Column E) and a different, specific text value in another cell (current row, Column F). If both are true, I want to write a specific number (“1”) into cell AJ (in the current row).

I hope I have explained this clearly.

Thanks in advance for any hints.

AJ2: =IF(AND(E2="specific text value";F2="a different, specific text value");1)

IF function.

1 Like

LeroyG, thank you so much, Sir!

1 Like