One way:

=I28 + 7 + 14*(COUNTIF(E28:E500,"TBG")0)

If TBG is a partial match, use

"*TBG*"

instead.

In article ,
"Connie Martin" wrote:

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