Volitile Formula

[Asha]

I have a client that has a spreadsheet with some very
difficult formula's. I have one that has a volitile
formula error. I am not sure what that means, I know the
formula is not right. Can someone help me. Here is the
formula. Do you see anything obvious?

=IF(OR(SUM($A2:$H2)=0,AND(OR($A2=">====> VOID
<====<",$A2="* Non Budget Item *"),$B2<>0,SUM($D2:$I2)
=0)),"",IF(AND($A2>0,$B2>0,$C2>0,$D2>0,$E2<>0,IF($Z2>0,OR
($Z2=TRUE),FALSE),$G2>0,$H2>=0,$D2<=TODAY(),TRUNC($J2)
=LOOKUP(TRUNC($J2),'Approved Codes'!$C$1:$C$287),OR(TRUNC
($J2)=LOOKUP(TRUNC($J2),'Approved Project Codes'!
$C$1:$C$224),OR
($F2="C",$F2="M",$F2="S",$F2="I",$F2="F",$F2="R",$F2="B",$F
2="W",$F2="V",$F2="P",$F2="T",$F2="O",$F2="L")),OR
($C1<>$C2,AND($A1=$A2,$B1=$B2,$C1=$C2,$D1=$D2,OR
($F1<>$F2,$G1<>$G2,$H1<>$H2))),OR($C2<>$C3,AND
($A2=$A3,$B2=$B3,$C2=$C3,$D2=$D3,OR
($F2<>$F3,$G2<>$G3,$H2<>$H3))),OR($I2=100,AND
($I2>0,$I2<100,OR(AND($C1=$C2,$E1=$E2,$J1<>$J2),AND
($C2=$C3,$E2=$E3,$J2<>$J3))))),IF($C2=$C3,IF($C2=$C4,IF
($C2=$C5,IF($C2=$C6,IF(OR
($C1=$C2,$I2+$I3+$I4+$I5+$I6=500,$I2+$I3+$I4+$I5+$I6=100),"
","Error"),IF(OR
($C1=$C2,$I2+$I3+$I4+$I5=400,$I2+$I3+$I4+$I5=100),"","Error
")),IF(OR
($C1=$C2,$I2+$I3+$I4=300,$I2+$I3+$I4=100),"","Error")),IF
(OR
($C1=$C2,$I2+$I3=200,$I2+$I3=100),"","Error")),""),"Error")
)

 

[Kevin Stecyk]

Asha,

I responded above when you posted the same message a few hours later.

In addition to what I wrote in your later message, I would add this: If you
don't understand it and the client doesn't understand it, I would be
inclined to start over with a fresh page. What do you want it to do, and
then organize your formula from there.

Regards,
Kevin