Forum Discussion
Accounting formula
Thank you in advance.
Simply, Have an invoice tracking spreadsheet that is returning incorrect numbers.
Let's say column A is what is due, column B is what is paid and I need column C to provide what is still due. Problem is, sometimes we are given part payments which returns a false answer.
The current formula Calculates A as $5000, B as $3000 (part payment) and C as $0.00 were it should be $2000 is still due.
Obviously this is simplified, there are several columns summing similar numbers then charting the answer.
14 Replies
- Obviously my understanding of a community help forum is not what I thought. Sorry to waste your time.
Sorry, I have simplified it to much. Actual formula =SUMIF(O2:O385,"<>",H2:H386) goes not help me if a part payment is received.
Column H is wages due. Columns F and G are the same but I calculate them separately (only way I know).
Column O is for payments received.
I will make sure any future questions are detailed.
Old_School Could you post a small data sample (not 300 rows, just 10) and put in the expected results manually? It's hard to visualise what you want to achieve.
