Hi there,
I've got a problem that I think should be solvable. My non-profit wants to calculate membership costs in pricing fields based on the user's response to two questions. But we don't want the user to see how this works behind the scenes, so we don't want any prices to appear before the total amount.
Here are the 2 questions that determine cost:
1. Please select the industry group that best describes your business*
Commercial Products/Services
Construction
Consumer Products
Education, Non-Profit & Government Entities
Financial & Insurance Services
Healthcare
Information Technology
Manufacturing
Professional
Transportation
2. Number of employees in U.S.*
1 – 750
751 – 1,000
1,001 – 1,500
More than 1,500
And here's the logic we want to implement:
- IF the answer question 1 is "Education, non-profit & government," THEN total is $950.00
- IF the answer to question 1 is NOT "Education, non-profit & government," AND answer to question 2 is...
"1 – 750" then total is $950.00
"751 – 1,000" then total is $1,875.00
"1,001 – 1,500" then total is $3,125.00
"More than 1,500" then total is $4,500.00
Thanks in advance for your help!
-Ben