Excel table equivalent to tree diagram

How do I create a 12-month table with several variables in Excel? Say I start with 5 possible X values and have two growth factors, each with 5 proposed values I want to test (Z1-5+Y1-5) through the end of the 12th month and see the product of each combination (125) like a large tree diagram would.

By: Scott Bole

Leave a Reply

Your email address will not be published. Required fields are marked *