I am working in Excel 2003 with a formula which has one ISERR and a total of
six vlookups. I am trying to have one cell look up values from other
worksheets and perform basic math on those values. In some instances I get
either #DIV/0! or #N/A!.

When I try to use both IF(ISNA) and IF(ISERR), an error message states that
my formula is too long. Is this because of the number of characters I am
typing into the cell or that I am trying to use more than 7 "formulas"? I
didn't think vlookups counted in that regard.

Is there any way to use both ISNA and ISERR at the same time? Something like:
IF(ISNA or ISERR ???
That would be just perfect...