What-if Tables

[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

 

[Andy]

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.