Forum Discussion
Solved
Solve for X with Functions
Hello everyone, I have a spreadsheet that I am trying to automate as much as allowed by policies. The issue I currently have could be solved with a Macro, Goal Seek, and even Solver, but we need ...
- So I think you just need a formula for column G to calculate what Variable (column E) needs to be to reach $0 cash total?:
=C2-B2-$M$4/(1+$J$4)/A2
So I think you just need a formula for column G to calculate what Variable (column E) needs to be to reach $0 cash total?:
=C2-B2-$M$4/(1+$J$4)/A2
=C2-B2-$M$4/(1+$J$4)/A2