G'day, Hope someone can help me out.
I have created a spreadsheet to track my work flow. I was hoping to have a dollar value in a certain cell that shows me my next incoming payment from the client.
it is currently keeping a running total of what I have been paid to date which is calculated from the H column. But thought it would be nice to have a quick reference cell showing my next incoming payment.
(please refer below)
So what i was thinking is
IF a cell in 'column F' has '100%', a date populated in the 'G column' and nothing in the H column. then add $25 to cell D5. (payment per job is a flat fee of 25 and never fluctuates)
D5 might not have a figure if I have just been paid and am back to square for the month.
I would be happy to create additional cells to make this work if it would be easier for my 'Next Payment Total' to reference another cell.
Any help would be appreciated.
Regards.
Mulder
I have created a spreadsheet to track my work flow. I was hoping to have a dollar value in a certain cell that shows me my next incoming payment from the client.
it is currently keeping a running total of what I have been paid to date which is calculated from the H column. But thought it would be nice to have a quick reference cell showing my next incoming payment.
(please refer below)
So what i was thinking is
IF a cell in 'column F' has '100%', a date populated in the 'G column' and nothing in the H column. then add $25 to cell D5. (payment per job is a flat fee of 25 and never fluctuates)
D5 might not have a figure if I have just been paid and am back to square for the month.
I would be happy to create additional cells to make this work if it would be easier for my 'Next Payment Total' to reference another cell.
Any help would be appreciated.
Regards.
Mulder
