Oct 28, 2015

Belajar Rumus IF di Excel 2010 Part II

By. diki - Google+
9:50 AM

Setelah pada postingan sebelum nya kita belajar contoh sederhana dari Belajar Rumus IF di Excel 2010, selanjutnya yuk mari kita lanjutkan untuk belajar rumus if ke part II atau yang tingkat lebih tinggi :).



Untuk tutorial langkah langkahnya kita langsung ubah aja rumus di formula bar nya, seperti gambar di bawah ini:



Sedangkan untuk data nya kita tetap masih pakai yang lama, seperti ini:


Coba mainkan rumus bar yang seperti contoh gambar di atas tadi dengan contoh rumus yang lain, seperti ini:
  1. =IF(A2=15; "Benar"; "Salah") adalah: Jika nilai di sel A2 sama dengan 15; tampilkan jawaban "Benar". Maka Hasilnya adalah: ("Benar")
  2. =IF(A2<>15; "Benar"; "Salah") adalah: Jika nilai di sel A2 tidak sama dengan/selain 15; tampilkan jawaban "Benar". Maka Hasilnya adalah: ("Salah") (*mengapa? karena angka di sel A2 adalah 15 maka jawabannya "Salah", karena yg kita cari adalah angka selain 15, kalau contoh angka di sel A2 selain angka 15 maka jawabannya adalah "Benar")
  3. =IF(NOT(A2<=15); "Benar"; "Salah") adalah: Jika nilai di sel A2 adalah bukan lebih kecil atau bukan sama dengan 15; tampilkan jawaban "Benar". Maka Hasilnya adalah: ("Salah")
  4. =IF(A5<>"SPROCKETS"; "Benar"; "Salah") adalah: Jika nilai di sel A5 tidak sama dengan/selain "SPROCKETS"; tampilkan jawaban "Benar". Maka Hasilnya adalah: ("Salah")
  5. =IF(AND(A2>A3; A2<A4); "Benar"; "Salah") adalah: Jika 15 adalah lebih besar dari 9 dan lebih kecil dari 8; tampilkan jawaban "Benar". Maka Hasilnya adalah: ("Salah")
  6. =IF(AND(A2<>A3; A2<>A4); "Benar"; "Salah") adalah: Jika 15 tidak sama dengan/selain 9 dan 15 tidak sama dengan/selain 8; tampilkan jawaban "Benar". Maka Hasilnya adalah: ("Benar")
  7. =IF(OR(A2>A3; A2<A4); "Benar"; "Salah") adalah: Jika 15 lebih besar dari 9 atau kurang dari 8; tampilkan jawaban "Benar". Maka Hasilnya adalah: ("Benar")
  8. =IF(OR(A5<>"Sprockets"; A6<>"Widgets"); "Benar"; "Salah") adalah: Jika nilai di sel A5 tidak sama dengan "Sprockets" atau "Widgets"; tampilkan jawaban "Benar". Maka Hasilnya adalah: ("Salah")
  9. =IF(OR(A2<>A3; A2<>A4); "Benar"; "Salah") adalah: Jika 15 tidak sama dengan/selain 9 atau 15 tidak sama dengan/selain 8; tampilkan jawaban "Benar". Maka Hasilnya adalah: ("Benar")
Selamat bermain rumus if excel 2010 part II , dan semoga cepat paham :)



Masih Bingung Fungsi IF?, Komen Aja di Bawah Gan, Ntar Coba Udin Bantu


Silahkan, anda bisa langsung comment di sini Langsung MUNCUL..
tapi yang sopan ya ... ^_^ :

72 comments:

  1. Replies
    1. udah muter kesana sini akhirnya nemu juga.
      makasih banyak udah ngajarin
      sejauh ini faham atas yg diinfokan
      salam kenal dari Bandung IT :)

      Delete
    2. KAMI SEKELUARGA TAK LUPA MENGUCAPKAN PUJI SYUKUR KEPADA ALLAH S,W,T
      dan terima kasih banyak kepada AKI atas nomor togel.nya yang AKI
      berikan 4 angka 8458 alhamdulillah ternyata itu benar2 tembus AKI.
      dan alhamdulillah sekarang saya bisa melunasi semua utan2 saya yang
      ada sama tetangga.dan juga BANK BRI dan bukan hanya itu AKI. insya
      allah saya akan coba untuk membuka usaha sendiri demi mencukupi
      kebutuhan keluarga saya sehari-hari itu semua berkat bantuan AKI..
      sekali lagi makasih banyak ya AKI… bagi saudara yang suka main togel
      yang ingin merubah nasib seperti saya silahkan hubungi KI JAYA WARSITO,,di no (((085-342-064-735)))
      insya allah anda bisa seperti saya…menang togel 175 JUTA , wassalam.


      dijamin 100% jebol saya sudah buktikan...sendiri....







      Apakah anda termasuk dalam kategori di bawah ini !!!!


      1"Dikejar-kejar hutang

      2"Selaluh kalah dalam bermain togel

      3"Barang berharga anda udah habis terjual Buat judi togel


      4"Anda udah kemana-mana tapi tidak menghasilkan solusi yg tepat


      5"Udah banyak Dukun togel yang kamu tempati minta angka jitunya
      tapi tidak ada satupun yang berhasil..







      Solusi yang tepat jangan anda putus asah... KI .JAYA WARSITO akan membantu
      anda semua dengan Angka ritual/GHOIB:
      butuh angka togel 2D 3D 4D SGP / HKG / MALAYSIA / TOTO MAGNUM / dijamin
      100% jebol
      Apabila ada waktu
      silahkan Hub: KI JAYA WARSITO DI NO: [[[085-342-064-735]]]


      ANGKA GHOIB: SINGAPUR 2D/3D/4D/



      ANGKA GHOIB: HONGKONG 2D/3D/4D/



      ANGKA GHOIB; TEXAS



      ANGKA GHOIB; TOTO/ MAGNUM 4D/5D/6D/



      ANGKA GHOIB; LAOS









      KAMI SEKELUARGA TAK LUPA MENGUCAPKAN PUJI SYUKUR KEPADA ALLAH S,W,T
      dan terima kasih banyak kepada AKI atas nomor togel.nya yang AKI
      berikan 4 angka 8458 alhamdulillah ternyata itu benar2 tembus AKI.
      dan alhamdulillah sekarang saya bisa melunasi semua utan2 saya yang
      ada sama tetangga.dan juga BANK BRI dan bukan hanya itu AKI. insya
      allah saya akan coba untuk membuka usaha sendiri demi mencukupi
      kebutuhan keluarga saya sehari-hari itu semua berkat bantuan AKI..
      sekali lagi makasih banyak ya AKI… bagi saudara yang suka main togel
      yang ingin merubah nasib seperti saya silahkan hubungi KI JAYA WARSITO,,di no (((085-342-064-735)))
      insya allah anda bisa seperti saya…menang togel 175 JUTA , wassalam.


      dijamin 100% jebol saya sudah buktikan...sendiri....







      Apakah anda termasuk dalam kategori di bawah ini !!!!


      1"Dikejar-kejar hutang

      2"Selaluh kalah dalam bermain togel

      3"Barang berharga anda udah habis terjual Buat judi togel


      4"Anda udah kemana-mana tapi tidak menghasilkan solusi yg tepat


      5"Udah banyak Dukun togel yang kamu tempati minta angka jitunya
      tapi tidak ada satupun yang berhasil..







      Solusi yang tepat jangan anda putus asah... KI .JAYA WARSITO akan membantu
      anda semua dengan Angka ritual/GHOIB:
      butuh angka togel 2D 3D 4D SGP / HKG / MALAYSIA / TOTO MAGNUM / dijamin
      100% jebol
      Apabila ada waktu
      silahkan Hub: KI JAYA WARSITO DI NO: [[[085-342-064-735]]]


      ANGKA GHOIB: SINGAPUR 2D/3D/4D/



      ANGKA GHOIB: HONGKONG 2D/3D/4D/



      ANGKA GHOIB; TEXAS



      ANGKA GHOIB; TOTO/ MAGNUM 4D/5D/6D/



      ANGKA GHOIB; LAOS

      Delete
  2. kalau bikin rumus tentang regular gmana gan ???

    ReplyDelete
  3. ini ada pertanyaan gan...

    sample fix :
    =IF(AND(AD19="LENGKAP";AD20="LENGKAP";AD21="LENGKAP";AD34="LENGKAP";AD33="LENGKAP";AD32="LENGKAP";AD31="LENGKAP";AD30="LENGKAP";AD29="LENGKAP";AD28="LENGKAP";AD27="LENGKAP";AD26="LENGKAP";AD25="LENGKAP";AD24="LENGKAP";AD23="LENGKAP";AD22="LENGKAP");"LENGKAP";"TIDAK LENGKAP")

    Jika sampai puluhan bahkan ribuan, maka rumus tidak akan mengenali.
    Bagaimana memperpendek rumus tsb akan dapat dilanjutkan ke bagian selanjutnya gan...? mohon pencerahan....

    misal (ini salah) :
    =IF(AND(AD19:AD22="LENGKAP");"LENGKAP";"TIDAK LENGKAP")

    ReplyDelete
  4. udinya sudah inailaihi #ngak_respon

    ReplyDelete
  5. detil sekali penjelasan formula if nya. saya juga tertarik dengan program excel ini tapi masih sangat dasarrrrr

    ReplyDelete
  6. Bagaimana rumus pengurangan persen

    ReplyDelete
  7. RE : cak wawanTuesday, 16 July, 2013

    Alif Tara menjawa :
    E3=IF(D3=8;"lengkap";"tidak lengkap")
    (D3) =COUNTA(B3:B10)
    ini yg ane tau,, xixixiii,,

    Kaharuddin James menjawab : =IF(COUNTIF(AD1:AD90000000,"LENGKAP")=COUNTA(AD1:AD90000000),"LENGKAP","TIDAK LENGKAP") semoga membantu
    Yesterday at 10:50am · Like · 1

    Ki Zoecrow Senggol Modot Menjawab :
    alternatif lain
    =IF(AD19:AD34="lengkap";"lengkap";"tidak lengkap") kmudian tekan Cntrl Sift Enter bersamaan / formula CSE
    23 hours ago · Like · 2

    selamat mencoba coba

    ReplyDelete
  8. excel memang mantap kalau dikuasai dg baik. saga jg lg belajar ttg excel ini.

    ReplyDelete
  9. program excel bisa membatu bngt pada pekerjaan kalo dipahami dengan baik. tutorial macam ini pasti banyak yang memerlukan. termasuk saya yang jug sedang belajar program excel. thank

    ReplyDelete
  10. Bagaimana membuat rumus excel seperti contoh berikut:
    S menjadi Special
    1 menjadi First
    2 menjadi Second
    Thanks...

    ReplyDelete
  11. Terimakasih, Penjelasan rumus IFnya benar-benar mantap....

    ReplyDelete
  12. jika KA adalah kasir, jika PA adalah Packing, jika GU adalah Gudang, selain itu Supervisor. itu gimana rumusnya bang?

    ReplyDelete
  13. [URL="http://agenvimaxasli.com/"]a[/URL][URL="http://agenvimaxasli.com/vimax-asli-canada-obat-pembesar-alat-vital-alami/"]n[/URL][URL="http://agenvimaxasli.com/vimax-proextender/"]e[/URL] [URL="http://agenvimaxasli.com/cara-pemesanan-vimax-kapsul-original-canada/"]b[/URL][URL="http://agenvimaxasli.com/info-penting-sebelum-bertransaksi/"]a[/URL][URL="http://agenvimaxasli.com/ciri-ciri-vimax-pills-asli-canada/"]n[/URL][URL="http://agenvimaxasli.com/manfaat-vimax-capsules-canada-asli-original/"]t[/URL][URL="http://agenvimaxasli.com/daftar-harga-promo-vimax-asli-canada/"]u[/URL] [URL="http://agenvimaxasli.com/testimoni-pengguna-vimax-asli-canada/"]s[/URL][URL="http://goo.gl/Q9FXUh"]u[/URL][URL="http://goo.gl/9iyu5i"]n[/URL][URL="http://goo.gl/g2dTQH"]d[/URL][URL="http://goo.gl/Jwz5g9"]u[/URL][URL="http://goo.gl/6q3uod"]l[/URL] [URL="http://goo.gl/LO0GYA"]g[/URL][URL="http://goo.gl/UMhFRJ"]a[/URL][URL="http://goo.gl/b31U7j"]n[/URL] [URL="http://goo.gl/4kagxG"]b[/URL][URL="http://goo.gl/Hd9cZx"]i[/URL][URL="http://goo.gl/msYzTy"]a[/URL][URL="http://goo.gl/FReuoT"]r[/URL] [URL="http://goo.gl/N9q7yd"]t[/URL][URL="http://goo.gl/gZifSY"]a[/URL][URL="http://goo.gl/KNFDT6"]m[/URL][URL="http://goo.gl/KWbEaE"]b[/URL][URL="http://goo.gl/o1DOLN"]a[/URL][URL="http://goo.gl/FmYcld"]h[/URL] [URL="http://goo.gl/wvDg2b"]r[/URL][URL="http://goo.gl/JRPzsF"]a[/URL][URL="http://goo.gl/FusGaq"]m[/URL][URL="http://goo.gl/7tBtQP"]e[/URL] [URL="http://goo.gl/VTBnjP"]:sundulgans[/URL][URL="http://goo.gl/b591fy"]:sundulgans[/URL][URL="http://goo.gl/9tniFY"]:sundulgans[/URL][URL="http://goo.gl/vUDbPI"]:sundulgans[/URL][URL="http://agenvimaxasli.com/category/alat-pembesar-penis/"]:sundulgans[/URL][URL="http://goo.gl/DR9qXk"]:sundulgans[/URL]

    ReplyDelete
  14. http://www.expert5th.in/packers-and-movers-bangalore/
    Best Movers and Packers in Bangalore
    Top 5 Packers and Movers Bangalore
    Packers and Movers in Bangalore

    ReplyDelete
  15. http://www.expert5th.in/packers-and-movers-gurgaon/
    Gurgaon Packers and Movers
    Gurgaon Movers and Packers
    Movers and Packers Charges in Gurgaon
    Packers and Movers Charges in Gurgaon

    ReplyDelete
  16. This comment has been removed by the author.

    ReplyDelete

  17. More info Click: Packers and movers mumbai OR Packers and movers in mumbai by
    http://www.local5th.in/packers-and-movers-mumbai/

    ReplyDelete
  18. tlg bantu gan, mslh bonus gajian

    jika masuk 6 hari maka dpt bonus 50000, tpi kalo' gak masuk 1 hari bonus dipotong 10000 begitu seterusnya, 2hari 20000 dst, thanks

    ReplyDelete
  19. Packers And Movers in Bangalore track records have demonstrated that we are the tried and true transporter in #Bangalore - India.Local Packers And Movers Bangalore customers incorporates multinationals, real open and private area organizations, medium and little scale commercial ventures and exchanging group, serving the people all over the nation.
    http://packersmoversbangalore.in/
    http://packersmoversbangalore.in/packers-and-movers-hosakerehalli-bangalore

    ReplyDelete
  20. Packers And Movers Delhi prompt moving, relocation and shifting services for people and corporation moving to Delhi and round the India. For Movers Packers Delhi city full target report on supply of revenue and effective Movers And Packers Delhi, contact today 08290173333. We include our network in major cities like Bengaluru, Bangalore, Gurgaon, Hyderabad, Chandigarh, Haridwar, Chennai, Noida, Mumbai, Pune, Jaipur, Lucknow, Patna, Bhopal, Bhubaneswar, Ahmedabad and Kolkata.
    http://packers-and-movers-delhi.in/
    http://packers-and-movers-delhi.in/packers-and-movers-delhi-high-court-delhi

    ReplyDelete
  21. I must say you had done a tremendous job,I appreciate all your efforts.Thanks alot for your writings......Waiting for a new 1...Please visit our wonderful and valuable website-
    http://packersmoverschennai.in/
    http://packersmoverschennai.in/packers-and-movers-jawahar...

    ReplyDelete
  22. Packers An Movers Kolkata who are great and excitedly prepared to serve you with brilliant essentials and eagerness. This most dependable association is known all over Kolkata for its endeavors with respect to our administrations given to customers. Local Packers Movers Kolkata are not reporting this disconnection but rather really we have been complimented this by our customers on our site for your support and fulfillment. Packers And Movers Midnapore give our administrations at a moderate rate costing you altogether short of what others. We allocate our relationship in your present city from which the exchange is been done, who are then dependable to you from on inquiry us.
    http://kolkatapackersmovers.in/
    http://kolkatapackersmovers.in/packers-and-movers-barabazar-kolkata

    ReplyDelete
  23. Excellent post! I must thank you for this informative read. I hope you will post again soon.
    MOVERS AND PACKERS BANGALORE act as sign given by you and in this way every movement from our side is dedicated to you. With the unobtrusive components of the most noteworthy associations of the city recorded with us, you can either reach them direct and interest for the free relocation refers to from them or you can approach the enquiry structure joined with us and get refers to from the recorded packers and movers particularly on your inbox or over your phone. This will assist you with sparing money on your privilege and you're significant time too.
    http://packers-and-movers-bangalore.in/

    ReplyDelete
  24. I like your website very much thanks for your share.all the imformation are useful for me,I will come again.Please visit here:
    http://bhubaneswarpackersmovers.in/
    http://bhubaneswarpackersmovers.in/packers-and-movers-bhubaneswar-to-jaipur

    ReplyDelete
  25. Thanks for sharing useful information for us.I really enjoyed reading your blog, you have lots of great content
    http://chandigarhpackersandmovers.in/
    http://chandigarhpackersandmovers.in/packers-and-movers-faridkot

    ReplyDelete
  26. i really like your blog, thanks for share...
    please visit are website..
    http://packersmoversmumbaicity.in/
    http://packersmoversmumbaicity.in/packers-and-movers-dhule-maharashtra

    ReplyDelete
  27. Makasih Gan, bisa menambah referensi untuk memahami Rumus IF

    ReplyDelete
  28. terima kasih banyak infonya, sukses selalu

    ReplyDelete
  29. Malam bg gmna sich cara nya mencari perbandingan lulus atau tidak lulus menggunakan rumus if

    ReplyDelete
  30. Welcome to QuickBooks Support Which variant of QuickBooks would you say you are utilizing? Are you likewise utilizing Payroll with your QuickBooks ? On the off chance that you confront any issue with your QuickBooks Payroll gve us an approach QuickBooks Tech Support Phone Number 1888-567-1159

    ReplyDelete
  31. QuickBooks Customer Service is one the best accounting assistance available which can be accessed through QuickBooks Tech Support Phone Number 1888-396-0208. The main reason for providing the assistance services is to resolve the QB Errors, and users can use QuickBooks Support Phone Number for QB Desktop, Mac Support, and Enterprise Support.

    ReplyDelete
  32. Get quick answers for all QuickBooks tech issues and errors.We are adept at giving arrangements inside least turnaround time. Our agents are always on their feet to locate the easiest answer for the issues of our clients.QuickBooks Payroll Tech Support Phone Number.

    ReplyDelete
  33. QuickBooks Enterprise Support 1888-396-0208 will assist you get timely and adequate QuickBooks Enterprise coaching. It can even assist you meet Intuit-certified professionals once you genuinely would like support. Once you ar at the official web site of apprehend, you're purported to get the following.

    ReplyDelete
  34. QuickBooks Technical Support Phone Number. From getting you set up to handling your taxes, Intuit makes sure your

    and employees are taken care of.

    ReplyDelete



  35. Sending Invoices but your Employees arent receiving them ? QuickBooks Support Phone Number.This software can keep the record of all the transactions and produce reports for various needs.
    Immediately Dial 1888-567-1159 to Talk to our Experts.

    ReplyDelete
  36. Intuit offers you its QuickBooks Support Phone Number 1888-396-0208. Pro advisor are available 24/7 to sort out your concerns regarding online QuickBooks. QB additionally have a data protection and data recovery services through NUMBER.

    ReplyDelete
  37. QuickBooks Enterprise Support Phone Number is a capable programming composed by Intuit. It is utilized for Small and medium size business to keep up records of working representatives bookkeeping data, pay including all the duties and exchanges are finished with them.

    ReplyDelete
  38. The POS Support 1800-291-2485 has a component that would keep up every one of the clients stocks with each arrangement in transit. The module for stock stores cost subtle elements, division, delineation, estimations, shading, bargains, values, status, vender data, purchaser data, reorder focuses, ALU, and UPC. If there should arise an occurrence of disarray or issues, the QuickBooks Point of Sales Support phone numbercan be utilized to contact the master board at the QuickBooks client benefit.

    ReplyDelete
  39. Online Business Analytics, This is an add-on tool which opens up numerous more options for QuickBooks Enterprise clients. This device helps in opening information in QuickBooks Enterprise software in such a way you don't have to enter subtle elements like numbers and so forth to run reports of any sort. It is advised to take the help from Enterprise Support 1800-291-2485 and get your Tool Install.

    ReplyDelete
  40. Many kinds of queries or QuickBooks related issue, then you are way in the right direction. You just give single ring at our toll-free QuickBooks Payroll Technical Support Number +-- .we will help you right solution according to your issue. We work online and can remove the technical problems via remote access and as soon as the problem occurs we will fix the same.

    ReplyDelete
  41. The first thing you will need to transfer your data file is you should have installed same versions of QuickBooks in both computer systems. The conversion is possible if you are using same versions of QuickBooks then you can proceed further. You can also get help about it at QuickBooks Support Phone Number 1800-291-2485.

    ReplyDelete
  42. Quickbooks Enterprise 24x7 Support Phone Number1888-557-6950 Would Definitely Help You Out In All Ways. Intuit Has A Unique Reputation In This Highly Advance Technology Environment. Which Makes QuickBooks In The Market Unique And Different From Rest Of The Support Service Provider? It Helps And Provides You The Unique Way To Resolve Your Intuit Related Issues.

    ReplyDelete
  43. Thanks for sharing. I hope it will be helpful for too many people that are searching for this topic.

    https://goo.gl/kduKt5
    https://goo.gl/PNi1ZN
    https://goo.gl/8zXedY
    https://goo.gl/1gWvQM

    ReplyDelete
  44. Thanks for sharing this marvelous post. I m very pleased to read this article.
    mcafee.com/activate | mcafee.com/activate | office.com/setup

    ReplyDelete
  45. Uttarakhand is a state of India situated in the north. It's famed for its several Uttarakhand Holiday Packages and pilgrimage Places and also beautiful natural environment replete with mountains, rivers, glaciers, abundant greenery and some other physical aspects. Its diverse flora and fauna along with the architecture of the bygone era retain attraction for your website avid holidaymakers. Visit Here: https://bit.ly/2t1aq7w

    ReplyDelete
  46. You would possibly crave For extra and points will experience sweeter than ahead of. Have the chance to dig deep into their significant assets and just take pleasure in the warmth of the human whole body. The sweet essence from their Usually total body is most likely to cause you to get there for more in gratification and ecstasy. Put together for the final word time period practical experience of getting more info daily life. The wild exciting awaits your existence at the rear on the shut doorways. These are often dependable pleasures of existence. Hygiene is of great great importance, which stunning Escorts in Bangalore target strongly on this part. Visit Here:https://bit.ly/2WLolfL

    ReplyDelete
  47. Quickbooks enterprise support Phone number
    Call us for QuickBooks Enterprise Support, call +1--833-400-1001 to resolve Quicbooks Enterprise problems. Contact the QuickBooks Enterprise Support Phone Number at +1--833-400-1001 to contact the official QuickBooks specialist.

    ReplyDelete
  48. QuickBooks accounting software created a benchmark in the area of accounting & bookkeeping. In the past few years, the demand for this software increased so much that the Intuit has to double the productivity. In this post, we are going to discuss the quickbooks error code 80029c4a. This informative post includes topics like its causes & resolution.However, if the error code persists – you can contact the certified QuickBooks technicians of QuickBooks Error Support. Or you can get in touch with them by making a call on their toll-free number .i.e. +1(800)396-7703.

    ReplyDelete
  49. Amazon Originals just as well known motion pictures and TV appears. Watch whenever, anyplace. The Prime Video application is accessible on a scope of mytvTVs, Amazon gadgets, cell phones, Blu-beam players, games consoles and spilling media gadgets. Prime Video from an incredible determination of mytv, Movies and more at regular low costs. Get the suppprt Read More

    ReplyDelete
  50. Guys just sharing, I've found this interesting! Check it out!
    Santorini Escort |

    Guys just sharing, I've found this interesting! Check it out!
    Escort Heraklion |


    Corfu Escort |


    Mykonos Escort |

    Copenhagen Escort |

    ReplyDelete