Forum Discussion
eminemaths
Jan 30, 2024Copper Contributor
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). ...
- Jan 30, 2024Put P1 in double quotes.
Detlef_Lewin
Jan 30, 2024Silver Contributor
Put P1 in double quotes.