Change And With Or in Complicated Function Maybe

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
1,554
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.
 

Some videos you may like

Excel Facts

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

Watch MrExcel Video

Forum statistics

Threads
1,099,142
Messages
5,466,924
Members
406,510
Latest member
wizekor

This Week's Hot Topics

Top