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


--
karambos
------------------------------------------------------------------------
karambos's Profile: http://www.excelforum.com/member.php...o&userid=16262
View this thread: http://www.excelforum.com/showthread...hreadid=541726

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

=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