B
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
"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