Quote:
Originally Posted by cphgeo
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
|
Hi Nigel,
Your formula is looking in H20 for just "ZnS" and so doesn't fire the TRUE condition of the IF formula if the cell contains "ZnS, Zn2SiO4". It doesn't matter how you format the new column it will always fire the FALSE condition of your formula if the text doesn't match exactly.
Could you give a sample of several rows of data and explain any given pattern to the "Descriptions"??? i.e. they always start with 3 characters and a comma and those are the only ones you're interested in...
Similar Threads
Threaded Mode
