Formula Help... [forecasting part values for a period]
The idea of this sheet is to forecast cost allocation. For example, row 3 is allocated 50% until the end of February. What I need the table to show is that 50% of costs are unallocated in Jan/Feb '22 and then from March the value jumps back to 100% as effectively that item become unallocated.
Current formula is:
=IF(DATE([Month 1]$4, [Month 1]$3, [Month 1]$2) >= $[Costed to]7, $[Monthly rate]7 * [%]@row, 0)
Which works perfectly where the % is 100.
When I try to alter this with an IF(OR(... then try to add an expression for it to put 50% of the monthly rate it fails (if % is <1).
Any advice appreciated.
Help Article Resources
Check out the Formula Handbook template!