Re: [belajar-excel] RE: Bagaimana Logical Expressionnya ya? VBA [1 Attachment]

[Jan Raisin]

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 <ba...@kingjim.co.id>:

>
>
>  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:* mas_nan...@yahoo.co.id
> *To:* belajar-excel@yahoogroups.com
> *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.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12