Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select cell from range based on input in excel xp | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Formula pull factor from chart based on value of diff field? | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) |