How can I write this formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

az-willie - 15 Jun 2006 15:10 GMT

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?

Signature

Computers run on smoke --- when the smoke leaks out --- the computer stops

Reply to this Message

Dav - 15 Jun 2006 15:19 GMT

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

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

Regards

Dav

Signature

Dav

Reply to this Message

Mikeopolo - 15 Jun 2006 15:20 GMT

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

Regards
Mike

Signature

Mikeopolo

Reply to this Message

Bernard Liengme - 15 Jun 2006 19:25 GMT

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

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address

> How can I write a formula for this:
>
[quoted text clipped - 5 lines]
> Is it possible to write a formula using 2 or more values to get a
> conclusion?

Reply to this Message