Formula Error:

[JaedenRuiner]

Two Formulas:

First: Works Just Fine (and yes it uses some VB Macro Functions to Calculate)

Balance($A88, CurBalance(VLOOKUP($B88, $B$19:$F$24, 4, TRUE),INDEX($B$25:$F$119,IF(ISNA(MATCH(INDEX($B$19:$B$24, MATCH($B88, $B$19:$B$24, 1), 1)-1,$B$25:$B$119,1)),1,MATCH(INDEX($B$19:$B$24, MATCH($B88, $B$19:$B$24, 1), 1)-1,$B$25:$B$119,1)+1),1):$F88, FALSE), $C88 = "X", $D88)

Second: This Function However, causes an "Error in Formula" (not parenthetical), and highlights the Bolded Word:

=IF(ISBLANK($A88), 0, Balance($A88, CurBalance(VLOOKUP($B88, $B$19:$F$24, 4, TRUE),INDEX($B$25:$F$119,IF(ISNA(MATCH(INDEX($B$19:$B$24, [B]MATCH[/B]($B88, $B$19:$B$24, 1), 1)-1,$B$25:$B$119,1)),1,MATCH(INDEX($B$19:$B$24, MATCH($B88, $B$19:$B$24, 1), 1)-1,$B$25:$B$119,1)+1),1):$F88, FALSE), $C88 = "X", $D88))

Why? All i'm doing is making sure a primary column is assigned. if Cell A# is blank, don't print anything. I could understand a computation error because if A# is blank then i get the #VALUE error in the Excel Cell. I want to eliminate that error message and just print a 0 in the column if the A# is blank, otherwise it should run my functions.

The issue is the Balance() function formula string works. I wrap it in IF(ISBLANK($A1), 0, [/i]Balance(...)[/i]) and the formula fails. Is there some embedded Stack limit or something for formulas?

Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner