how to make formular If X is less then Y then X-W=Z

[jaredlawler]

Hi,

Thanks for your help on this.

I want to solve the following problem.

If X is less then Y then X-W=Z

But if X is Greater then Y = 0 (zero)

Thanks guys

Cheers
Jared

[Pepe Le Mokko]

Hi
perhaps first adapt your title as per forum rules?

[SDCh]

If X is less then Y then X-W=Z

you mean the result on column Z1?

=IF(X1<Y1,X1-W1,IF(X1>Y1,0,"X=Y"))

[jaredlawler]

Hey SDCH,

Thats spot on!. Thanks for your help.

cheers
Jared

[SDCh]

Glad your problem solved, and thanks for the rep

Note:
By the way, can you mark this thread as solved? Thanks.