Fungsi IF (bagian 1)

SOAL BISA DIKERJAKAN MULAI HARI RABU (10 APRIL 2013) JAM 07.00 WIB
SOAL DITUTUP HARI RABU (10 APRIL 2013) JAM 22.00 WIB

TULISKAN RUMUS UNTUK MENCARI HADIAH PADA SOAL BERIKUT

10-04-2013 0-14-02

KETENTUAN :

  1. Seseorang mendapat hadiah : TV LED 50Inch jika mempunyai poin minimal 50.
  2. Untuk poin di bawah 50, akan mendapat Sepeda Lipat

 
RUMUS HARAP DITULIS PADA KOLOM KOMENTAR

22 thoughts on “Fungsi IF (bagian 1)

  1. 1. =IF(C2>50,”TV LED 50Inch”,”Sepeda Lipat”)
    2. =IF(C3>50,”TV LED 50Inch”,”Sepeda Lipat”)
    3. =IF(C4>50,”TV LED 50Inch”,”Sepeda Lipat”)
    4.=IF(C5>50,”TV LED 50Inch”,”Sepeda Lipat”)
    5. =IF(C6>50,”TV LED 50Inch”,”Sepeda Lipat”)
    6. =IF(C7>50,”TV LED 50Inch”,”Sepeda Lipat”)
    7. =IF(C8>50,”TV LED 50Inch”,”Sepeda Lipat”)
    8. =IF(C9>50,”TV LED 50Inch”,”Sepeda Lipat”)
    9. =IF(C10>50,”TV LED 50Inch”,”Sepeda Lipat”)
    10. =IF(C11>50,”TV LED 50Inch”,”Sepeda Lipat”)

  2. 1. Wisya Astuti -> Rumus : =IF(C2 Rumus : =IF(C3 Rumus : =IF(C4 Rumus : =IF(C5 Rumus : =IF(C6 Rumus : =IF(C7 Rumus : =IF(C8 Rumus : =IF(C9 Rumus : =IF(C10 Rumus : =IF(C11<50,"Sepeda Lipat","TV LED 50inch")

  3. 1. Wisya Astuti : =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C2<50,"sepeda lipat")) | sepeda lipat

    • 1. Wisya Astuti : =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C2<50,"sepeda lipat")) | sepeda lipat

      • 1. Wisya Astuti : =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C2<50,"sepeda lipat")) | sepeda lipat

  4. =IF(C2>=50, “TV LED 50inch”, “Sepeda Lipat”)
    =IF(C3>=50, “TV LED 50inch”, “Sepeda Lipat”)
    =IF(C4>=50, “TV LED 50inch”, “Sepeda Lipat”)
    =IF(C5>=50, “TV LED 50inch”, “Sepeda Lipat”)
    =IF(C6>=50, “TV LED 50inch”, “Sepeda Lipat”)
    =IF(C7>=50, “TV LED 50inch”, “Sepeda Lipat”)
    =IF(C8>=50, “TV LED 50inch”, “Sepeda Lipat”)
    =IF(C9>=50, “TV LED 50inch”, “Sepeda Lipat”)
    =IF(C10>=50, “TV LED 50inch”, “Sepeda Lipat”)
    =IF(C11>=50, “TV LED 50inch”, “Sepeda Lipat”)

  5. RUMUS NYA SEBAGAI BERIKUT :
    1. Wisya astuti adalah =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

    NAMA :TUTI ALAWIYAH
    KELAS : XI.IPA.2

  6. RUMUS NYA SEBAGAI BERIKUT :
    • =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

    NAMA :TUTI ALAWIYAH
    KELAS : XI.IPA.2

  7. JAWAB!!!!
    1. Waisya astuti mendapatkan TV LED 50inch dengan
    Rumus : =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

    Ayu Dwi Sapta Riska Putri XIIPA 2

  8. ANSWER
    =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

    Name: Hadis Akbari
    Class: XIIPA 2

  9. 1.Wisya astuti
    Rumus : =C2>50 mendapatkan TV LED 50 inci
    2.Susiana
    Rumus : =C3<50 mendapatkan sepeda lipat
    3.Ely ermawati
    Rumus : =C450 mendapatkan TV LED 50 inci
    5.Nisa salsabila
    Rumus : =C6>50 mendapatkan TV LED 50 inci
    6.Sulistiyowati
    Rumus : =C750 mendapatkan TV LED 50 inci
    8.Ubay
    Rumus : =C9>50 mendapatkan TV LED 50 inci
    9.Shelly
    Rumus : =C10<50 mendapatkan sepeda lipat
    10.utami
    rumus : =C11<50 mendapatkan sepeda lipat

    devi oktaria F.R
    XI.IPA 2

  10. Jawab:
    =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

    Nurul desnainar fauzia
    XIIPA 2

  11. =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

    mardianti XIIPA 2

  12. syahila zulfa nadira (XI IPA 2)

    nih pak jawabannya :
    RUMUS :
    =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

  13. =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

    gherinneu olivia afradiva
    XIIPA 2

  14. Jawaban:
    Berikut ini adalah rumusnya:
    =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

    Nama : Istica Sugi Mulyowati
    Kelas : XI IPA 2

  15. Rumus: =IF(C2>50,”TV LED 50 INCH”,IF(C250,”TV LED 50 INCH”,IF(C350,”TV LED 50 INCH”,IF(C450,”TV LED 50 INCH”,IF(C550,”TV LED 50 INCH”,IF(C650,”TV LED 50 INCH”,IF(C750,”TV LED 50 INCH”,IF(C850,”TV LED 50 INCH”,IF(C950,”TV LED 50 INCH”,IF(C1050,”TV LED 50 INCH”,IF(C11<50,"sepeda lipat"))

  16. Jawab: 1.=IF(C1>50,”TV LED 50 INCH”,”Sepeda Lipat”), 2.=IF(C2>50,”TV LED 50 INCH”,”Sepeda Lipat”), 3.=IF(C3,”TV LED 50 INCH”,”Sepeda Lipat”), 4.=IF(C4,”TV LED 50 INCH”,”Sepeda Lipat”), 5.=IF(C5,”TV LED 50 INCH”,”Sepeda Lipat”), 6.=IF(C6,”TV LED 50 INCH”,”Sepeda Lipat”), 7.=IF(C7,”TV LED 50 INCH”,”Sepeda Lipat”), 8.=IF(C8,”TV LED 50 INCH”,”Sepeda Lipat”), 9.=IF(C9,”TV LED 50 INCH”,”Sepeda Lipat”), 10.=IF(C10,”TV LED 50 INCH”,”Sepeda Lipat”),11.=IF(C11,”TV LED 50 INCH”,”Sepeda Lipat”).

    Bayu Aji Pratama
    XI IPA 2

  17. =IF(C2>50;”TV LED 50 INCH”;”sepeda lipat”)
    =IF(C3>50;”TV LED 50 INCH”;”sepeda lipat”)
    =IF(C4>50;”TV LED 50 INCH”;”sepeda lipat”)
    =IF(C5>50;”TV LED 50 INCH”;”sepeda lipat”)
    =IF(C6>50;”TV LED 50 INCH”;”sepeda lipat”)
    =IF(C7>50;”TV LED 50 INCH”;”sepeda lipat”)
    =IF(C8>50;”TV LED 50 INCH”;”sepeda lipat”)
    =IF(C9>50;”TV LED 50 INCH”;”sepeda lipat”)
    =IF(C10>50;”TV LED 50 INCH”;”sepeda lipat”)
    =IF(C11>50;”TV LED 50 INCH”;”sepeda lipat”)

    Benny purnama XI-IPA 2
    Sori pa telat set jam

  18. Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin

Tinggalkan Pesan Anda Disini

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s