What-if Tables

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Can anyone explain how to create a table that in Lotus 1-
2-3 was called a What-if Table. It allows you to solve
an equation with three variables. For example, what
would your monthly payments be if you borrowed X amount
for Y months at Z interest rates

Thanks for your help
 
Michael

Go to Help, and in the Answer Wizard type 'what-if analysis'. This will
bring a list back, one of which is 'Ways to forecast values with what-if
analysis'. It should point you in the right direction.

Andy.
 
Back
Top