View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ldillon13 ldillon13 is offline
external usenet poster
 
Posts: 1
Default 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!!!