# Change And With Or in Complicated Function Maybe

##### Well-known Member
hi all..

i have following problem to modify this formula:
Code:
``=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.

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

#### Special-K99

##### Well-known Member
Can't you just encase it within

• 