View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default formula returning incorrect blanks

When CH14 is blank, ISNUMBER perceives it as a non-numeric so the IF is
returning the "false" value, a blank. I'm trying to think of
workarounds, and without knowing the rationale for the ISNUMBER the
best I can think of is to enter a zero instead of a blank.