I have listed below the formula that I have that sort of works. The only
issue is that the 12 is actually 12" and I can't seem to add the " to the
value. Is there something I can do to work this out. I tried putting """ to
add the quote or adding " inside the "marks for the motorBD value....but it
is not working.
=IF(DischargeHeadMfg="American
Turbine",IF(MotorBD="12","Standard","Premium"),"No t Applicable")

TIA