View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Art Art is offline
external usenet poster
 
Posts: 587
Default I need help with cell returning number as credit or debit

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.



"ldillon13" wrote:

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!!!