Hi and thanks for helping.
I'd like to apply a known deposit amount (B1) to a set of projected income for the year (B3 - M3)
If the monthly income is less than the deposit a "No Invoice" is returned under the related month (example B4 & C4)
If the deposit is applied, but there is a remainder due, the adjusted invoice amount is returned (example D4 = $5000)
If there is no impact from the deposit cells remain blank (example E4 Apr)
Projects can start on any month.
<tbody>
</tbody>
I'm open to other recommendations.
Thanks again.
I'd like to apply a known deposit amount (B1) to a set of projected income for the year (B3 - M3)
If the monthly income is less than the deposit a "No Invoice" is returned under the related month (example B4 & C4)
If the deposit is applied, but there is a remainder due, the adjusted invoice amount is returned (example D4 = $5000)
If there is no impact from the deposit cells remain blank (example E4 Apr)
Projects can start on any month.
A | B | C | D | E | ETC. | |
1 | Deposit | $25,000.00 | ||||
2 | Month | Jan | Feb | Mar | Apr | Etc. |
3 | Estimated Income by Labor Hours | $10,000.00 | $12,000.00 | $8,000.00 | $7,500.00 | |
4 | Adjusted Invoice Amount | No Invoice | No Invoice | $5,000.00 |
<tbody>
</tbody>
I'm open to other recommendations.
Thanks again.