[milis-belajar-excel] NEED HELP RUMUS IF BERTINGKAT DENGAN BEBERAPA KONDISI

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] NEED HELP RUMUS IF BERTINGKAT DENGAN BEBERAPA KONDISI

Maulidin
Assalamulaikum 

Selamat beribadah berpuasa bagi yg melaksanakan 

mohon sekiranya dapat membantu ide rumus yg tepat , beberapa kali di coba dengan mengcombine if dengan and atau or selalu saja hasilnay tidak sesuai dengan apa yg di ingin kan 
 
">

terima kasih sebelumnya apabila berkenan membantu 

terlampir deskripsi case di attachment 

salam hangat 

Emye 

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1148387615.1095120.1619593880501%40mail.yahoo.com.

1619593660952blob.jpg (97K) Download Attachment
Belajar if bertingkat dengan beberapa kondisi.xlsx (16K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [milis-belajar-excel] NEED HELP RUMUS IF BERTINGKAT DENGAN BEBERAPA KONDISI

iqbal

Hi Emyee,

Sebelum ada pencerahan dari master, bisa di coba dengan ini

=IF(B4="100% - 0%",IF(E4="",NOW(),E4),IF(H4="",NOW(),H4))

 

 

Thanks

BR
Iqbal

 

From: '[hidden email]' via milis Belajar-Excel <[hidden email]>
Sent: Wednesday, April 28, 2021 2:11 PM
To: Milis belajar excel Belajar-Excel <[hidden email]>
Subject: [milis-belajar-excel] NEED HELP RUMUS IF BERTINGKAT DENGAN BEBERAPA KONDISI

 

Assalamulaikum 

 

Selamat beribadah berpuasa bagi yg melaksanakan 

 

mohon sekiranya dapat membantu ide rumus yg tepat , beberapa kali di coba dengan mengcombine if dengan and atau or selalu saja hasilnay tidak sesuai dengan apa yg di ingin kan 

 

Jadikan gambar sebaris

terima kasih sebelumnya apabila berkenan membantu 

 

terlampir deskripsi case di attachment 

 

salam hangat 

 

Emye 

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1148387615.1095120.1619593880501%40mail.yahoo.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/01f801d73cd8%24b6b92b30%24242b8190%24%40gmail.com.
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] NEED HELP RUMUS IF BERTINGKAT DENGAN BEBERAPA KONDISI

Maulidin
Dear Iqbal 

Logic formula nya berhasil thanks banget support nya  


Warm Regards
Emye 
Pada Kamis, 29 April 2021 16.19.25 WIB, <[hidden email]> menulis:


Hi Emyee,

Sebelum ada pencerahan dari master, bisa di coba dengan ini

=IF(B4="100% - 0%",IF(E4="",NOW(),E4),IF(H4="",NOW(),H4))

 

 

Thanks

BR
Iqbal

 

From: '[hidden email]' via milis Belajar-Excel <[hidden email]>
Sent: Wednesday, April 28, 2021 2:11 PM
To: Milis belajar excel Belajar-Excel <[hidden email]>
Subject: [milis-belajar-excel] NEED HELP RUMUS IF BERTINGKAT DENGAN BEBERAPA KONDISI

 

Assalamulaikum 

 

Selamat beribadah berpuasa bagi yg melaksanakan 

 

mohon sekiranya dapat membantu ide rumus yg tepat , beberapa kali di coba dengan mengcombine if dengan and atau or selalu saja hasilnay tidak sesuai dengan apa yg di ingin kan 

 

Jadikan gambar sebaris

terima kasih sebelumnya apabila berkenan membantu 

 

terlampir deskripsi case di attachment 

 

salam hangat 

 

Emye 

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1148387615.1095120.1619593880501%40mail.yahoo.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/01f801d73cd8%24b6b92b30%24242b8190%24%40gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/415275740.2013879.1619924413027%40mail.yahoo.com.