0 Replies Latest reply on May 1, 2014 8:46 AM by WolfgangsCH

    Help with Checkbox that fills based on conditions in two combo boxes.

    WolfgangsCH

      Hi, New here and novice. I need help with a script that will fill a check box based on the range of numerical values in two combo boxes. I've been searching for days but have been unable to find anything. Can anyone offer any help? Thanks in advance!

       

      Here's my example:

      If the product meets two particular criteria it qualifies for one of three rebate amounts. I have two comboboxes "SEER" (containing values of 13.0 to 25.0 in quarter increments) and "EER" (containing values of 10.0 to 14.0 in quarter increments)  and four check boxes "none", "$200", "$300", and "$400".

       

      If the product "SEER" is =<14.99 and "EER" is =>10.0 then the "none" box is checked.

      If the product "SEER" is =>15.0 but <15.99 and "EER" is =<12.0 then the "$200" box is checked.

      If the product "SEER" is =>16.0 but <16.99 and "EER" is =<12.0 then the "$300" box is checked.

      If the product "SEER" is =>17.0  and "EER" is =<12.0 then the "$400" box is checked.