Cell wording should change if result is +ve or -ve

I have a calculation with one cell containing the result. The wording next to the cell should read

"Jane owes Peter:" if the result of the calculation is positive
and
"Peter owes Jane:" if the result is negative but it should show the absolute value.

I am grateful for any help

=if(a1=b1,"No debt",if(a1<b1,"Jane owes Peter: ","Peter owes Jane: "))
& text(abs(a1-b1),"$0.00")

You can use the text() worksheet function to give the difference a nice format.

=if(a1=b1,"No debt",if(a1<b1,"Jane owes Peter: ","Peter owes Jane: "))
& text(abs(a1-b1),"$0.00") & " due on: " & text(c1,"mm/dd/yyyy")

(if you had the date in C1)

karambos wrote:
>
> I have a calculation with one cell containing the result. The wording
> next to the cell should read
>
> "Jane owes Peter:" if the result of the calculation is positive
> and
> "Peter owes Jane:" if the result is negative but it should show the
> absolute value.
>
> I am grateful for any help
>
> --
> karambos
> ------------------------------------------------------------------------
> karambos's Profile: http://www.excelforum.com/member.php...o&userid=16262
> View this thread: http://www.excelforum.com/showthread...hreadid=541726

--

Dave Peterson