| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding text and performing a calculation
Is it possible to look for a string of text in a cell, then perform a
calculation? Example: A1 = Senior Thesis Research (this column also contains data like "Lab Thesis") B1 = 10 C1 = 5 If the word "Thesis" is in A1, multiply B1*C1, if it's not, enter zero. The formula I tried works, but when a cell in column A doesn't have the word "Thesis" I get "#Value!" error. The formula I tried is: =IF(FIND("Thesis",A1)0,B1*C1,0) Thanks in advance. Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| performing regression | New Users to Excel | |||
| a more efficient way of performing this calculation? | Excel Discussion (Misc queries) | |||
| Performing arithmetic functions to cells with number and text | Excel Discussion (Misc queries) | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Threaded Mode
