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($A20,$B20,$C20,$D20,$E2<0,IF($ Z20,OR
($Z2=TRUE),FALSE),$G20,$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
($I20,$I2<100,OR(AND($C1=$C2,$E1=$E2,$J1<$J2),AN D
($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),"","Erro r")),IF
(OR
($C1=$C2,$I2+$I3=200,$I2+$I3=100),"","Error")),"") ,"Error")
)

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


"Asha" wrote in message
...
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($A20,$B20,$C20,$D20,$E2<0,IF($ Z20,OR
($Z2=TRUE),FALSE),$G20,$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
($I20,$I2<100,OR(AND($C1=$C2,$E1=$E2,$J1<$J2),AN D
($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),"","Erro r")),IF
(OR
($C1=$C2,$I2+$I3=200,$I2+$I3=100),"","Error")),"") ,"Error")
)