It is possible to disallow a combination of options in the pricing calculator pricing engines. If the user selects a disallowed combination, they will get a message that says, "That combination of choices is not allowed." The method for setting this up will depend upon if you are using grid or pricing parameters.
In the grid, for the combination that should be disallowed, you would delete the contents of the pricing cell. The disallowed combination in your spreadsheet would look like this:
The result would look like this:
You would need to use a custom "Applies To" (column E). You would use an ifn statement. See this example:
In the example, the custom applies to is:
ifn(Paper=”Gloss”, Q1, -1)
This means that if the Paper option equals gloss, then the value is Q1, otherwise the value is -1. If the user chooses Matte, then the value will be -1. The calculator parameter has a minimum value of 1. Therefore if the user chooses Matte paper and folding yes, then the value is disallowed. The engine will return the " "That combination of choices is not allowed." message.