SOLVED

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

Copper Contributor

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.

1 Reply
best response confirmed by eminemaths (Copper Contributor)
Solution
Put P1 in double quotes.
1 best response

Accepted Solutions
best response confirmed by eminemaths (Copper Contributor)