How can I write this formula?

A

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?
 
B

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
 
Top