I simple solution I've used in similar cases, or where you want inputs to be mutually exclusive (such as a series of Boolean inputs driving a calculation) is to use conditional formatting. Line item: Error format IF Product A = Product B then 10 else 0 That way you can flag it as red or some other color to indicate an input error. Not completely error proof, but quick and simple.
... View more
