Quantcast

[belajar-excel] IF BERTINGKAT

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[belajar-excel] IF BERTINGKAT

bucin
Assalamu`alaikum....

Dear Exceller

ada yang mau saya tanyakan tentang rumus IF bertingkat
mohon bantuannya

Terima kasih

Wassalamu`alaikum..

IF BERTINGKAT.xls (28K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] IF BERTINGKAT

abeutthank
Rumus asli
=IF(G2="x";"pass";IF(G2=0;G2-F2;IF(G2>F2;"Lunas
"&"(+"&G2-F2&")";IF(G2=F2;"Lunas";G2-F2))))

Rumus di modif
=IF(ISTEXT(G2);(IF(G2="x";"pass";0));IF(G2=0;G2-F2;IF(G2>F2;"Lunas
"&"(+"&G2-F2&")";IF(G2=F2;"Lunas";G2-F2))))

IF(G2=F2;"Lunas";G2-F2 --> y merah kok gak ngaruh ya :(


2013/1/10 Masbooqien Al qodiriyah <[hidden email]>

> **
>
>
> Assalamu`alaikum....
>
> Dear Exceller
>
> ada yang mau saya tanyakan tentang rumus IF bertingkat
> mohon bantuannya
>
> Terima kasih
>
> Wassalamu`alaikum..
>
>  
>



--
R125
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] IF BERTINGKAT

bucin
In reply to this post by bucin
terimah kasih atas bantuannya

yang merah coba di ganti,insya Allah beubah  : )
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] IF BERTINGKAT

booqien
This post has NOT been accepted by the mailing list yet.
In reply to this post by abeutthank
terimah kasih atas bantuannya

yang merah coba di ganti,insya Allah beubah  : )



2013/1/10 abeutthank [via Milis Belajar Excel] <[hidden email]>
Rumus asli
=IF(G2="x";"pass";IF(G2=0;G2-F2;IF(G2>F2;"Lunas
"&"(+"&G2-F2&")";IF(G2=F2;"Lunas";G2-F2))))

Rumus di modif
=IF(ISTEXT(G2);(IF(G2="x";"pass";0));IF(G2=0;G2-F2;IF(G2>F2;"Lunas
"&"(+"&G2-F2&")";IF(G2=F2;"Lunas";G2-F2))))

IF(G2=F2;"Lunas";G2-F2 --> y merah kok gak ngaruh ya :(


2013/1/10 Masbooqien Al qodiriyah <[hidden email]>

> **
>

>
> Assalamu`alaikum....
>
> Dear Exceller
>
> ada yang mau saya tanyakan tentang rumus IF bertingkat
> mohon bantuannya
>
> Terima kasih
>
> Wassalamu`alaikum..
>
>  
>


--
R125



If you reply to this email, your message will be added to the discussion below:
http://milis-belajar-excel.1048464.n5.nabble.com/belajar-excel-IF-BERTINGKAT-tp5714564p5714572.html
To start a new topic under Milis Belajar Excel, email [hidden email]
To unsubscribe from Milis Belajar Excel, click here.
NAML

Loading...