Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Credit and Debit formating
I have workbook that has one tab that pending credits and charges are
entered by associates who are not Excel suavy. That information is linked to a cell for reconcilation. The purpose is to figure a inventory. How it works is actual count plus pending items to come up with a new inventory balance. The problem is I need to add back into the inventory the credits and take out the charges. Do to the fact that these credit debits are entered in the same place. What I am trying to do is convert the credit to charges and subtract the debit (opposite of value). Is there a formula that can do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to do a Worksheet for my Financial Accounting Class. What . | Excel Worksheet Functions |