software

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 =, lt;, or gt;, than D, and giving the result in
E):

If B9 C9=D9, then 0
but if B9 C9gt;D9, then B9 C9-D9 (to show that quot;Dquot; is x-amount less than
B C)
but if B9 C9lt;D9, then D9-B9 C9 (to show that quot;Dquot; is x-amount more than
B C)

Am I making sense?

LOL - I'm sure I'm close, but I keep getting the quot;too many argumentsquot;
error
THANK YOU--
navychef
------------------------------------------------------------------------
navychef's Profile: www.excelforum.com/member.php...oamp;userid=29457
View this thread: www.excelforum.com/showthread...hreadid=493602
=if((b9 c9)=d9,0,if((b9 c9)gt;d9,b9 c9-d9,d9-b9 c9))--
Vito
------------------------------------------------------------------------
Vito's Profile: www.excelforum.com/member.php...oamp;userid=29182
View this thread: www.excelforum.com/showthread...hreadid=493602
Awesome, I knew I came to the right place.

THANKS MUCH!--
navychef
------------------------------------------------------------------------
navychef's Profile: www.excelforum.com/member.php...oamp;userid=29457
View this thread: www.excelforum.com/showthread...hreadid=493602