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

N

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?:confused:

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

:)

THANK YOU
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF/AND Statements in Comp Calculator 15
excel template for calculating trial balances and adjusting entri. 2
Why doesn't this work ? 2
DCOUNT Unique Values 2
IF function with value_if_true and value_if_false as equations 4
The sum of the same function that is used for a range of cells 2
IF(AND with date comparison 4
Formatting Formula Results 1

Top