Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default #N/A

The below formula is returning #N/A after hitting enter.
How do I get rid of this?

=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",$F2="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")
)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"