Forum Discussion
Accounting formula
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.
Column F Wage 1
Column G Wage 2
Column H Wage 3
Column I Total Wages
Column J Net amount
Column K Tax
Column L Total
Column M Payment date
Column N Amount paid
Column O Amount outstanding
I am trying to calculate how much is due to each person (columns F,G,H). If Column O is zero, then I do not want to calculate wages as they are already paid. Secondly, sometimes a part payment is made and it throws the calculations out. Ideally, If $10000 is due and $2000 is paid, then the $2000 would be divided equally reducing the amount due in wages.
Not a good start to my first question and I do apologise.
Old_School Again, can you post a data sample? I mean a few rows of data with numbers and the expected result as a number as well. You can attach an Excel workbook when you post a reply. There is a "Choose Files" button below the reply text box.
