Thread: Sumif help

Hello, hoping someone can help me with the following function:

Solving for G1 and H1
If the amount in E1 is greater than the amount in F1 then the difference goes into G1
If the amount in E1 is less than the amount in F1 then the difference goes into H1

Example #1:
E1= $100
F1= $105
G1 should be $0
H1 should be $5

Example #2:
E1= $105
F1= $100
G1 should be $5
H1 should be $0

Any help would be greatly appreciated!!

Thanks

Greg

Hi,

In G1 use:

=IF(E1>F1,E1-F1,0)

and in H1 use:

=IF(E1<F1,F1-E1,0)

Cheers,