Untitled conversation

  1. 2 tahun lalu

    dear rekan saya butuh pencerahan nih, ada masalah di logika excel yang saya buat.
    logikanya seperti ini :

    =IF(OR(IF(AND(ISNUMBER(H2),H2>0),"true",IF(H2="up","true","false")),IF(AND(ISNUMBER(I2),I2>0),"true",IF(I2="up","true","false")),IF(AND(ISNUMBER(J2),J2>0),"true",IF(J2="up","true","false")),IF(AND(ISNUMBER(K2),K2>0),"true",IF(K2="up","true","false")),IF(AND(ISNUMBER(L2),L2>0),"true",IF(L2="up","true","false")),IF(AND(ISNUMBER(M2),M2>0),"true",IF(M2="up","true","false")),IF(AND(ISNUMBER(N2),N2>0),"true",IF(N2="up","true","false")),IF(AND(ISNUMBER(O2),O2>0),"true",IF(O2="up","true","false")),IF(AND(ISNUMBER(P2),P2>0),"true",IF(P2="up","true","false")),IF(AND(ISNUMBER(Q2),Q2>0),"true",IF(Q2="up","true","false")),IF(AND(ISNUMBER(R2),R2>0),"true",IF(R2="up","true","false")),IF(AND(ISNUMBER(S2),S2>0),"true",IF(S2="up","true","false")),IF(AND(ISNUMBER(T2),T2>0),"true",IF(T2="up","true","false")),IF(AND(ISNUMBER(U2),U2>0),"true",IF(U2="up","true","false")),IF(AND(ISNUMBER(V2),V2>0),"true",IF(V2="up","true","false")),IF(AND(ISNUMBER(W2),W2>0),"true",IF(W2="up","true","false")),IF(AND(ISNUMBER(X2),X2>0),"true",IF(X2="up","true","false")),IF(AND(ISNUMBER(y2),y2>0),"true",IF(y2="up","true","false"))),"UP","DOWN")

    dan pesan error nya seperti ini : the specified formula cannot be entered because it contains more values, references and/or names than are allowed in the current file format

  2. binggung

  3. Oh..itu mah karna ente pakai format file excel 2003 / kebawah( extensi .xls)... Karna di format excel tsb, nest atau limit untuk logika IF adalah 7 atau 8 IF .
    Cara mengatasinya agan bisa pakai/save as file dg format excel 2007 keatas(extensi .xlsx) .

 

atau Mendaftar untuk ikut berdiskusi!