M Max Jan 8, 2008 #2 C said: How can I replace a #N/A result with "0"? Click to expand... One way, trap the formula's return with ISNA, eg: =IF(ISNA(yourformula),0,yourformula) ---
C said: How can I replace a #N/A result with "0"? Click to expand... One way, trap the formula's return with ISNA, eg: =IF(ISNA(yourformula),0,yourformula) ---
