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.
|