I need the very next cell in the row to be the difference left between the sum of the previous cells in the row.
ISDProjectedGrossMargins2020_3_27.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | |||
56 | Recognize | Funded | % | Book | Mos. | Dec | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 | Sep-20 | Jan-00 | Dec-20 | |||
57 | 200,000 | 0 | 30% | 7/19 | 7 | ||||||||||||||||
58 | 0 | Y | 330% | 4 | |||||||||||||||||
59 | 21,000 | 0 | 20% | 6/19 | 4 | ||||||||||||||||
60 | 128,000 | 128,000 | 99% | 3/20 | 6 | 0 | 0 | 13,653 | 13,653 | 13,653 | 13,653 | 13,653 | 13,653 | 0 | 0 | 0 | 0 | ||||
61 | 530,000 | 530,000 | 70% | 4/20 | 7 | 0 | 0 | 0 | 48,457 | 48,457 | 48,457 | 48,457 | 48,457 | 48,457 | 48,457 | 0 | 0 | ||||
62 | 350,000 | 35% | 5/20 | 6 | 0 | 0 | 0 | 0 | 37,333 | 37,333 | 37,333 | 37,333 | 37,333 | 37,333 | 0 | 0 | |||||
Projected Margins 11x17 (2) |
Cell Formulas | ||
---|---|---|
Range | Formula | |
R60:AC62 | R60 | =IF(AND(R$56>=$O60,R$56<EDATE($O60,$P60)),(($K60/$P60)*0.64),0) |
L57:L61 | L57 | =IF($C57<>"D",K57,0) |