I need help with cell returning number as credit or debit

[Guest]

OK - It's been a long time since I've had to do this. Here is my situation:

If cell C2 is 100.00 and cell D2 is 80.00, and I subtract D2 from C2, the
answer will be a debit which is fine. My problem is this:

How do I format it so that if C2 is 100.00 and D2 is 120.00 and I subtract
D2 from C2, it puts the answer as a credit of 20.00?

HELP!!!

 

[Guest]

I'm not entirely sure what you want to do -- but the following will display
20.00 CR if you subtract 120 from 100.

Format the cell with the answer with a custom format as follows:
0.00;0.00 "CR"

You can put anything you like in between the quotes instead of CR if that's
appropriate.

 

[Guest]

c2-d2 = + or - difference based on values of c2 and d2
100 - 80 = + 20
100 - 120 = -20
The only time there would be a problem is when c2 or d2 is a negative number
in which case some folks multiply one of the cells by (-1) to compensate
force a positive value. This is only good if you want to always display the
difference as a positve value.