Change And With Or in Complicated Function Maybe

[muhammad susanto]

hi all..

i have following problem to modify this formula:

=IF(AND(E2=0;MAX(IFERROR(AB2/P2;0);IFERROR(AC2/Q2;0);IFERROR(AD2/R2;0);IFERROR(AE2/T2;0))<=1500000);HLOOKUP(N2;Depresiasi_ok!$B$7:$F$109;AG2+3;FALSE)/100;IF(AND(E2=0;MAX(IFERROR(AB2/P2;0);IFERROR(AC2/Q2;0);IFERROR(AD2/R2;0);IFERROR(AE2/T2;0))>1500000);HLOOKUP(N2;Depresiasi_ok!$G$7:$K$109;AG2+3;FALSE)/100;HLOOKUP(N2;INDIRECT(VLOOKUP(M2&IF(V2<=VLOOKUP(M2;Depresiasi_ok!$BE$4:$BF$25;2;FALSE);"<=";">")&VLOOKUP(M2;Depresiasi_ok!$BE$4:$BF$25;2;FALSE);Depresiasi_ok!$BG$4:$BH$25;2;FALSE));AG2+3;FALSE)/100))

my target is, how to change cell IF(AND(E2=0 with IF(OR(E2=0.......
i mean if in cell E2 contains data (given) the formula is work correctly but otherwise if in cell E2 is blank formula not working..

i hope someone would help me out.

sst.

 

[Special-K99]

Can't you just encase it within

IF(E2="","", your formula)