ini dari help excel 2007 Up to 64 IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. Alternatively, to test many conditions, consider using the LOOKUP, VLOOKUP, or HLOOKUP function.
excel 2007 bisa nampung sampe 64 IF sekaligus, kalau anda pake excel yang lebih rendah, mungkin batasannya juga lebih rendah, bisa 8 atau 7... makanya error... seperti yang lain, saran saya mending anda pake lookup, lalu table lookupnya di hide biar ga mengganggu pemandangan... dimaspramana wrote: > 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 -- When modern people always involved in crime There's no case can't be solved Sinichi Kudo -- Adi D. Jayanto "A Brand New Life of... Me"
