HelpExcelHelpers
New Member
- Joined
- May 5, 2018
- Messages
- 15
FORMULA for O6: This is my Remaining amount I need displayed for the year, however, I need the information pulled from one cell before another cell is pulled.
K6 (last year amount)+L6(amount I can rollover to next year)+M6(amount I borrowed from the next year)-N6(the amount I used for the year)=
when I enter an amount "used" in N6, I need this amount to pull from K6 first until it reaches zero then I need it to pull from L6 then adding the borrowed amount from M6 subtracting the used amount from N6 to give me a remaining total.
K6 (last year amount)+L6(amount I can rollover to next year)+M6(amount I borrowed from the next year)-N6(the amount I used for the year)=
when I enter an amount "used" in N6, I need this amount to pull from K6 first until it reaches zero then I need it to pull from L6 then adding the borrowed amount from M6 subtracting the used amount from N6 to give me a remaining total.