If, but, and still but, all in one formula?

[navychef]

I've also been playing with this, trying to use either IF, or SUMIF, or
SUMPRODUCT, trying to make this work (adding B+C, compare with D, and
determine if the sum is =, <, or >, than D, and giving the result in
E):

If B9+C9=D9, then 0
but if B9+C9>D9, then B9+C9-D9 (to show that "D" is x-amount less than
B+C)
but if B9+C9<D9, then D9-B9+C9 (to show that "D" is x-amount more than
B+C)

Am I making sense?

LOL - I'm sure I'm close, but I keep getting the "too many arguments"
error



THANK YOU

 

[Vito]

=if((b9+c9)=d9,0,if((b9+c9)>d9,b9+c9-d9,d9-b9+c9)

 

[navychef]

Awesome, I knew I came to the right place.

THANKS MUCH