Help in IF formula

[ranthrave]

Hello sir/maam
Kindly help me with this IF formula.

D87= 394
G84 = 521

My formula
G87 = IF((D87-G84) >D87, D87, D87-G84)

My problem is G87 must be zero if D87 less than or equal to G84.
IF D87 is greater than G84 it should be D87-G84.

Tnx for helping me

 

[T. Valko]

Hello sir/maam
Kindly help me with this IF formula.

D87= 394
G84 = 521

My formula
G87 = IF((D87-G84) >D87, D87, D87-G84)

My problem is G87 must be zero if D87 less than or equal to G84.
IF D87 is greater than G84 it should be D87-G84.

Tnx for helping me

Try this...

=IF(COUNT(D87,G84)<2,"",IF(D87<=G84,0,D87-G84))

 

[ranthrave]

Try this...

=IF(COUNT(D87,G84)<2,"",IF(D87<=G84,0,D87-G84))

Tyvm

 

[T. Valko]

Tyvm

You're welcome!