TRUE/FALSE

[Stclements1]

=IF($L2>0,AND($N2>0,"1"))
=IF($L2>0,N2>0,"1")
=IF($L2>0,AND($N2>0,"1","0"))

In cell P2 I have tried the above formulas, If the conditions are met then P2 should display 1 but each time I try I get either TRUE if they are met or FALSE if not. How can I write the formula to return 1 if met or leave the cell blank if not?

 

[FormR]

Hi, it should be more like this.

=IF(AND($L2>0,$N2>0),1,"")

 

[Stclements1]

Hi, it should be more like this.

=IF(AND($L2>0,$N2>0),1,"")

Hi, it should be more like this.

=IF(AND($L2>0,$N2>0),1,"")

 

[Stclements1]

Totally perfect, many thanks.