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