select based on word CDS being in description field
I have a column in a spreadsheet of data which describes certain investments.
A certain type of investment's description always contains the initial
"cds". I would like a formula to look at the field and if the letters cds
appear (in that order) I would like do some math on other parts of the record.
For example if cell b1 contains the letters cds, then add cell c1 and d1,
else 0)
Any help would be appreciated
Joe
--
Joe D
|