# How do I calculate a matrix with conditions?

• NSC1958
Asked on January 20, 2017 at 09:02 PM

I am building a registration form.  I have created a matrix where it illustrates the programs and days that one can consider.  The programs include Canskate, Pre-power, Adult learn, Primary, Intermediate, and Senior.  They can also choose different day options.

For Canskate, they can only choose one day.  How do I restrict Canskate to only 1-day choice.  Also the cost for 1-day is \$300.  These conditions and calculations apply for Power.

For Primary, they can choose 2 days.  Again, I need restrict the day choices to a maximum of 2.  The cost for 1 day is \$300, and the cost for 2-days is \$55.  This also applies to Primary, but 1-day is \$725, and 2-days is \$975.

For Intermediate, they can choose 3 days.  This time we need to restrict the day choices to a maximum of 3.  The cost for 1-day is \$750, 2-days is \$1,000, and 3 days is \$1,225.  This also applies to Senior but the cost for 1-day is \$825, 2-days is \$1,125, and 3-days is \$1,400.

I would like the result to populate in a box.  How do I do this?  Your help is much appreciated.

• AIDAN
Answered on January 21, 2017 at 07:37 AM