Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need help with cell returning number as credit or debit
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. "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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up a debit and credit formula on the worksheet | Excel Worksheet Functions | |||
Debit/credit amount Slection How? | Excel Discussion (Misc queries) | |||
Credit and Debit formating | Excel Discussion (Misc queries) | |||
Highlight the debit and Credit ( positive and negative) numbers within a column | Excel Programming |