Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Find Text problem
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Find Text problem
Hello Sammy The Find function returns a #Value! error if the string you ar searching for is not found. To make your code work, you need to tes for the error. Did you mean to search for the value of B15 in "FEE" o vice versa. I assumed the opposite. *Revised Formula: = IF(ISERROR(FIND("Fee", B15))=FALSE, E14, E14+C15 Sincerely Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=49770 |
#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 |
Reply |
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 |