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