No, using the “OR” operator here is not correct.
What you want to do is to nest the if-statements.
{{if(contains(14.supplier_normalized; "drive"); "drive"; if(contains(14.supplier_normalized; "ns3"); "ns3"; null))}}
(copy-paste the above into the field, or type it exactly as shown)
e.g.:
(second if-statement underlined in red)
Hope this helps! If you are still having trouble, please provide more details.
— @samliew