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
or solving for Q
