I do not mean another cell by P1, I mean the cell value.

Hello.

I would like to use the following formula : =IF(AND($D2=P1, F2=1, S2=1, Q2=1), "1", "0"). At the beginning of formula with $DR=P1 and by P1, I mean the value (what is written in cell D2). Excel automatically think that P1 is the cell P1. I do not mean cell P1, I mean P1 as a value of D2, what is written in D2.

How can I stop it interpreting P1 as the cell?

Thanks.