How can I use the breakeven formula RV(Q)=TFC + VCU (Q) when Q is unknown or solving for Q
P PW Apr 3, 2004 #1 How can I use the breakeven formula RV(Q)=TFC + VCU (Q) when Q is unknown or solving for Q
N Niek Otten Apr 3, 2004 #2 Use Tools>Goal Seek Let's assume A1 has the formula TFC + VCU (Q) - RV(Q) Tools>Goal Seek, "Set Cell" is A1, "To Value" is 0, "By changing cell" is the cell where you have Q -- Kind Regards, Niek Otten Microsoft MVP - Excel PW said: How can I use the breakeven formula RV(Q)=TFC + VCU (Q) when Q is unknown Click to expand... or solving for Q
Use Tools>Goal Seek Let's assume A1 has the formula TFC + VCU (Q) - RV(Q) Tools>Goal Seek, "Set Cell" is A1, "To Value" is 0, "By changing cell" is the cell where you have Q -- Kind Regards, Niek Otten Microsoft MVP - Excel PW said: How can I use the breakeven formula RV(Q)=TFC + VCU (Q) when Q is unknown Click to expand... or solving for Q
