R Rosemary Jan 27, 2004 #1 Hello! Is there anyway I can assign an "isblank" and "iserr" formula to an entire spreadsheet?
J JE McGimpsey Jan 27, 2004 #2 For IsBlank, you can probably get the result you're after with =COUNTA(Sheet1!1:65536)=0 This can substitute for IsError (which is TRUE for #N/A, which IsErr isn't): =NOT(ISNUMBER(SUM(Sheet1!1:65536)))
For IsBlank, you can probably get the result you're after with =COUNTA(Sheet1!1:65536)=0 This can substitute for IsError (which is TRUE for #N/A, which IsErr isn't): =NOT(ISNUMBER(SUM(Sheet1!1:65536)))
