I have a sheet for pricing variations of a product. Some variations are held in stock, some aren't and some are special order.
This is part of the calc:
IF(B14=63,"NO Stock",IF(B14=65,A14*C14*1044,IF(B14=80,"NO Stock",IF(B14=85,A14*C14*1184,IF(B14=100,"NO Stock",
65 and 85 will return...