I need help with cell returning number as credit or debit
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!!!
|