View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HUGO HUGO is offline
external usenet poster
 
Posts: 30
Default If logical function with text and numbers

Hi,

I have a row with dates. Every three cells are a date in months, which excel
recognizes as a date, but every fourth cell is the quarterly date, which
excel recognizes as text.

I would like to write an if function that can discriminate between the date
values and the text values. In words, what I would like it to do is this:
"if a cell is text, return a sum, if not, return nothing".

Any help would be greatly appreciated.

Thanks!
--
Hugo