Thread: formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
beepee beepee is offline
external usenet poster
 
Posts: 2
Default 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