how about
=l28+if(countif(e28:e500,"TBG")0,14,7)
or
l28+7+if(countif(e28:e500,"TBG")0,7,0)

--
Don Guillett
SalesAid Software

"Connie Martin" wrote in message
...
Another simple one, I'm sure. I have this simple formula: =I28+7

I want to add to this that it's to add 14 if "TBG" is found in E28:E500,
otherwise add only 7.

Connie