pake fasilitas fungsi lookup. lebih simpel dan kalo mau tambah kondisi
berapapun gak ribet. sintaks lengkapnya liat di buku aja yah.....
dimaspramana <[EMAIL PROTECTED]> 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
---------------------------------
Yahoo! Movies - Search movie info and celeb profiles and photos.
[Non-text portions of this message have been removed]
