How do I calculate a matrix with conditions?

  • Profile Image
    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.

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

    Hi Karlene, I believe I have already addressed your request via the other thread that you created:

    Thank you.