Missing a test condition...

[daver676]

Hello!

Here is my formula:

=DSUM('830ASCII'!$A:$E,'830ASCII'!$D$1,Criteria!C137138)-
(IF(ISNA(VLOOKUP
(A108&"*"&"Total",Shipping,2,FALSE)),0,VLOOKUP(A108&"
*"&"Total",Shipping,2,FALSE)+IF(ISNA(VLOOKUP(A108&"-
R"&"*Total",Shipping,2,FALSE)),0,VLOOKUP(A108&"-
R"&"*Total",Shipping,2,FALSE))))

I am trying to test for two conditions, but as soon as the
first ISNA becomes true, Excel seems to disregard the rest
of the formula, and doesn't test for the second ISNA.

The basic format of the formula is:
number - (number + number), in other words:
DSUM - (VLOOKUP + VLOOKUP)

Any ideas?
Thanks a bunch!
Dave

 

[Biff]

Hi Dave,

See the other post for some thoughts. I've been wondering
about what you mean when you say when the first isna
becomes true. It's either true or false. If it's true that
means the vlookup has returned #N/A and therefore 0 and
that portion of the formula stops at that point. I'm
beginning to wonder what A108&"*"&"Total" actually means.
Is 'Total' a named formula? And what about the
wildcard '*'? I would look at A108&"*"&"Total" as the
source of the problem.

Biff