Forum Discussion
Accounting formula
Yes Columns P and Q are self calculating but based on manual entries from Column O. Columns F,G and H are also manual entries inputted after an invoice is produced.
I only want to calculate what the total is for F,G and H if Column P has a balance outstanding. I need individual formulas for F, G and H placing the answer in any blank cell. The only variance would be if Column O has a part payment.
Old_School I don't know how to say it any more clearly. Please post a sample with the expected results filled in manually.
I really don't have a clue what your desired end state looks like.
Please post a version of your data sample that has this desired end state. You say you only want to calculate X if there is Y, but you don't say in WHICH CELLS you want to perform these calculations and what the result should be.
Please mock that up in your data sample, so I know what to aim for.
This is my last attempt at trying to coax the desired result out of you. If you cannot show me what you need to see IN A SPREADSHEET, I will have to abandon this question.