hi,
i have a spreadsheet with a description column containing multiple text entries (a short description of minerals).
i would like to extract and code the text into a new column.
an example of the data is

Description
ZnS, Zn2SiO4

i would like the function to then populate the new column with
ZM, ZBM

i have tried some IF functions but nothing happens!
here is one i tried
=if(H20="ZnS", ["ZM"])

when i enter this in the new code column it just enters that text in the cell!
what should the new column be formatted for )text, number etc) and is the formula correct?

thanks
nigel