View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sammy sammy is offline
external usenet poster
 
Posts: 48
Default 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?