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

select based on word CDS being in description field
 

=ISNUMBER(FIND("cds",B1)) will return TRUE if "cds" is in cell B1. So you
can build from there; ex: =if(isnumber(find("cds",b1)),c1+d1,0)
--Bruce


"Joe D" wrote:

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

select based on word CDS being in description field
 

Thanks, that's perfect.

--
Joe D


"bpeltzer" wrote:

=ISNUMBER(FIND("cds",B1)) will return TRUE if "cds" is in cell B1. So you
can build from there; ex: =if(isnumber(find("cds",b1)),c1+d1,0)
--Bruce


"Joe D" wrote:

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