Here is a fun excel formula that I have developed which has contributed to my psychosis.
=IF(AND(H43<$H$37,I43<$I$37,J43<$J$37),$G$37,IF(AND(H43<$H$38,I43<$I$38,J43<$J$38),$G$38,IF(AND(H43<$H$39,I43<$I$39,J43<$J$39),$G$39,IF(AND(H43<$H$40,I43<$I$40,J43<$J$40),$G$40))))
That formula combines with other, similar formulas to feed variables into the formula below.
=IF($H$32="Single",$H$44,K43&"T "&IF($H$33="Clear",,IF(OR($H$33="Gray",$H$33="Bronze"),$H$33,IF($H$33="Clear",,"Q"&$H$33)))&" / "&L43&" FBD"&" / "&IF($H$34="Clear",,IF(OR($H$34="Gray",$H$34="Bronze"),$H$34,IF($H$34="Clear",,"Q"&$H$34)))&" ")&K43&"T"
That formula generates a complete order string for an insulated glass lite which contains tempering information, Low-E choices, tint options, glass thicknesses, and spacer bar information to submit to a glass manufacturer.