revisi script.. biar bisa digunakan dengan formula Excel yang lain.. file terlampir
Wassalam, -Miss Jan Raisin- Pada 5 Februari 2014 16.31, Jan Raisin <[email protected]> menulis: > > > nyumbang solusi pake UDF ya.. > formulanya: > =JenisDistribusi( Skewness , CoefficientOfVariation , Kurtosis ) > > pastikan macro diizinkan berjalan di komputer anda > file terlampir > > > Salam, > > -Miss Jan Raisin- > > > 2014-02-05 Bagus <[email protected]>: > >> >> >> Hai Nandha; >> >> Coba begini: >> =IF(OR(I7>=-1,I7<=0.5),"normal",IF(OR(OR(I7>=2.5,I7<=3.5),I8>=2.5,I8<=3.5),"log >> normal",IF(AND(OR(I7>=0.51,I7<=1.5),OR(I9>=5,I9<=5.8)),"gumbel","log >> pearson"))) >> >> >> >> Wassalam >> >> ~ Bagus ~ >> >> >> >> ----- Original Message ----- >> *From:* [email protected] >> *To:* [email protected] >> *Sent:* Wednesday, February 05, 2014 3:46 PM >> *Subject:* [belajar-excel] RE: Bagaimana Logical Expressionnya ya? VBA >> [1 Attachment] >> >> >> >> ini pak jan cntoh worksheetnya, kira2 seperti apa ya logicalnya? saya >> bingung >> >> >> >> terima kasih >> >> >
re-buat milis_rev1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
