How can I write this formula?

[az-willie]

How can I write a formula for this:

If C4>0 AND if P4>0 then 1 else 0

I've been trying to write a formula to do this and can't seem to get it
right.

Is it possible to write a formula using 2 or more values to get a
conclusion?

 

[Dav]

If C4>0 AND if P4>0 then 1 else 0

if(and(C4>0,P4>0),1 , 0)

Regards

Dav

 

[Mikeopolo]

=if(and(C4>0,P4>0),1,0)

Regards
Mike

 

[Bernard Liengme]

Without using IF:
(C4>0)*(P4>0)
Can be expanded
(C4>0)*(P4>0)*(Z4=1)

The multiplication gives AND logic; to get OR logic use addition
(C4>0)+(P4>0) gives 1 if either cell is greater than 0

best wishes