Thread: Can a calculation ignore text if it occurs in formula's cell range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sally
 
Posts: n/a
Default Can a calculation ignore text if it occurs in formula's cell range
I have formula strings that include cells that can contain numbers or text.
Can I (easily) create calculations that ingnore text occurances rather than
returning a '#VALUE!'
Reply With QuoteReply With Quote