Thread: Value Return
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frick
 
Posts: n/a
Default Value Return

In cells from C2:K2, some cells have either a number or a letter. What I
like to have is a formula like If(sum(C2:K2) have anything in them numbers,
letters, return value 1, otherwise return 0) It's easy if there are numbers
in any given row, but the letters are throughing me off. How can this be
handled.