Salam Disebuah cell saya buat formula sbb =IF(H375=38,400,IF(H375=40,440,IF(H375=44,510,IF(H375=46,550, IF(H375=49,600,IF(H375=50,630,IF(H375=52,670,IF(H375=54,700)))))))) berjalan normal.
Tapi kalo logicalnya saya tambah lagi satu bh misalna if(H357=36,300 & tanda kurung tutupna ditambah lagi satu bh formulanya jadi error, lengkapna sbb =IF(H375=36,300,IF(H375=38,400,IF(H375=40,440,IF(H375=44,510,IF (H375=46,550, IF(H375=49,600,IF(H375=50,630,IF(H375=52,670,IF(H375=54,700))))))))) apa karena kebanyakan gitu, barangkali ada cara lainna?. Wasalam DP
