If/Then Simple but stuck

[deltasd]

I am trying to write a formula that lists when we owe and when we are due. One cell lists the total amount of funds distributed, another lists amount spent. I want one cell that reads if one cell is greater than the other, zero is due and if less than, the difference in the two numbers. The other cell is to read the opposite; if it is less than, the difference is owed, if greater, it should read zero. I've tried variations of =IF(C41>C42,0)*IF(C41<C42,"SUM"). Can you point me in the right direction?

 

[Joe4]

Welcome to the Board!

I don't know if you question is entirely clear, because you mention "if one number is greater/less than the other", but don't mention which one.
But I think you can use the MIN/MAX functions to do what you want, i.e.

=MIN(C41-C42,0)

will return C41-C42, but will return 0 if that value is negative.

And

=MAX(C41-C42,0)

will return C41-C42, but will return 0 if that value is positve.

 

[etaf]

One cell lists the total amount of funds distributed, another lists amount spent.

so is that cell C41 & C42

I want one cell that reads if one cell is greater than the other,

C41>C42
so if C41 is greater than C42 - Zero is due

=IF( C41>C42, 0,

if it is less than, the difference is owed,

So if its not greater than , it MUST be equal or Less

=IF( C41>C42, 0,

the difference is owed,

so C41 is greater then C41 - C42 is the difference

=IF( C41>C42, 0, C41-C42)

what if its equal

 

[deltasd]

so is that cell C41 & C42

C41>C42
so if C41 is greater than C42 - Zero is due

=IF( C41>C42, 0,



So if its not greater than , it MUST be equal or Less

=IF( C41>C42, 0,


so C41 is greater then C41 - C42 is the difference

=IF( C41>C42, 0, C41-C42)

what if its equal

I am so sorry my explanation wasn't very clear. I should have stated C41 totals actual expenses and C42 totals funds advanced. C43 is amount due them and C44 is amount due us. If equal, then should be zero. Your formula worked perfectly, even if equal it just zeroed them both, which is accurate. Thank you very kindly!

 

[Joe4]

Note that the first formula I posted:

=MIN(C41-C42,0)

is equivalent to:

=IF(C41>C42,0,C41-C42)

and simpler/shorter.

The MIN and MAX functions are very useful functions.
I suggest you read up in them.

 

[etaf]

you are welcome