| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Find Text problem
A couple of ways:
=E14+ISNUMBER(SEARCH("fee",B15))*C15 or =E14+IF(ISNUMBER(SEARCH("fee",B15)),C15,0) Sammy wrote: How do I simply find text in a string within a cell and if true add the value from another string and if false simply keep the current value for a running total. When I enter the formula IF(FIND(B15,"FEE"),E14,E14+C15) It returns the #VALUE! error. In this example I am placing this in cell E15 to create a running total of all fees charged. How do I format the formula to get an IF THEN ELSE type solution? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| simple find | Excel Worksheet Functions | |||
| Simple question to find min value | Excel Programming | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
| So simple I can't find the answer! | Excel Programming | |||
Threaded Mode
