formulas
 

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

formulas
 

=IF(ISNUMBER(FIND("C",C36)),D36+60)+IF(ISNUMBER(FI ND("E",C36)),D36+60)
--
Gary''s Student - gsnu200814


"beepee" wrote:

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

formulas
 

thanx a bunch, bp

"Gary''s Student" wrote:

=IF(ISNUMBER(FIND("C",C36)),D36+60)+IF(ISNUMBER(FI ND("E",C36)),D36+60)
--
Gary''s Student - gsnu200814


"beepee" wrote:

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