formulas

[beepee]

In a cell which contains a single alpha character (A thru F), I need to
"query/select" all "C" or "E" presence and advance an associated "date" by 60
days.

Below I can "FIND" the "C" only:

=IF(ISNUMBER(FIND("C",C36)),D36+60)

How can I "FIND" the "E" also?

I'm thinking, if I copy the formula to each row, I should get response only
when a "C" or "E" are presence. When an "A, B, D or F" are present, nothing
shoiuld happen.

thanx,

bp

 

[Gary''s Student]

=IF(ISNUMBER(FIND("C",C36)),D36+60)+IF(ISNUMBER(FIND("E",C36)),D36+60)

 

[beepee]

thanx a bunch, bp

=IF(ISNUMBER(FIND("C",C36)),D36+60)+IF(ISNUMBER(FIND("E",C36)),D36+60)