HOME P H P C S S Tips and Trik Kontes SEO

Formula IF Dasar Excell 2007

Microsoft Excell atau Spreadsheet adalah salah satu software analisa data yang sering kita gunakan, ada banyak function yang kita dapat manfaatkan. Salah Satunya fungsi IF. Berikut kami tampilkan beberapa modifikasi penggunaan fungsi IF di Excell

Cara 1 : Menggunakan Fungsi IF Tunggal 
Berdasarkan kondisi data pemohon tersebut kita akan menerima pegawai dengan syarat hanya mereka yang memiliki pendidikan S1 yang akan diterima (Lulus), maka fungsi yang kita gunakan adalah :

=IF(C5="S1";"Lulus";"Gagal")

Artinya : Jika nilai Cell C5 memiliki nilai S1 maka akan dinyatakan Lulus dan jika nilai Cell C5 bukan S1 akan dinyatakan Gagal.

Cara 2 : Menggunakan Fungsi OR
Syarat yang kita gunakan adalah hanya kepada pemohon yang mempunyai pendidikan S1 dan D3 yang kan kita terima (Lulus) dan selain dari itu akan dinyatakan Gagal. fungsi yang kita gunakan :

=IF(OR(C5="S1";C5="D3");"Lulus";"Gagal")

Artinya : Jika Cell C5 mengandung nilai S1 dan D3 maka akan dinyatakan Lulus dan bila tidak dinyatakan Gagal.

Cara 3 : Menggunakan Fungsi AND
Syarat yang digunakan adalah pemohon yang kita terima adalah pemohon yang memiliki pendidikan S1 dengan jurusan Akuntansi, Fungsi yang kita gunakan :

=IF(AND(C5="S1";D5="Akuntansi");"Lulus";"Gagal")

Artinya : Jika Cell C5 memiliki nilai S1 dan Cell D5 meiliki nilai Akuntansi maka dinyatakan Lulus dan jika tidak dinyatakan Gagal.

Cara 4 : Menggunakan Fungsi NOT
Syaratnya adalah hanya pemohon yang meiliki jurusan Selain Akuntansi yang akan kita terima (Lulus). Fungsi yang kita gunakan :

=IF(NOT(D5="Akuntansi");"Lulus";"Gagal")

Artinya : Jika Cell D5 memiliki nilai Akuntansi maka akan dinyatakan Gagal, dan dinyatakan lulus jika Cell D5 bukan Akuntansi.

Cara 5 : Menggunakan Fungsi IF Bersarang
Syarat adalah jika pemohon memiliki pendidikan S1 akan langsung dinyatakan Lulus, jika berpendidikan D3 akan dipertimbangkan dan selain dari itu akan langsung dinyatakan Gagal.

=IF(C5="S1";"Lulus";IF(C5="D3";"Dipertimbangkan";"Gagal"))

Artinya : Jika Cell C5 memiliki nilai S1 maka akan dinyatakan gagal, Jika bukan S1 dan memiliki nilai D3 akan dinyatakan Dipertimbangkan dan jika bukan S1 atau D3 akan dinyatakan Gagal.

Demikian dan semoga bermanfaat buat kita semua

11 comments:

  1. obνiouslу liκe yоur
    ωeb-site but yοu nеed to taκe a
    look аt thе spellіng on sеveгal of your pоsts.
    Many of them аrе гife wіth spelling isѕues and I find
    іt vеrу bothersomе to tell the
    realіty nеvеrthеless I
    will certainly come agaіn agаin.
    Here is my website ... http://voyantvision.net/documentation/index.php?title=Time-To-Rocket-Your-Internet-Marketing-Business-Into-The-Stratosphere

    ReplyDelete
  2. 7 WCLH ( Format: Cοllegе Radio Wilkes University's radio station plays mostly alternative rock, but Mondays have seemingly always been "Metal Mondays. The broadcasting process is not complicated as all the equipments essential are easily available but with new ideas coming up every day, new requirements rise with new criteria of transmission like Dab Digital Radio and DRM. Proffering multifarious benefits to the advertisers, it is a quintessential resort for companies big or small.

    Look into my site; videos von youtube downloaden
    Also see my webpage :: youtube downloader online

    ReplyDelete
  3. I'm one of those who will try every "easy" diet, but because of my lack of willpower, I either stay overweight or gain it all back after I lose it. HIV and Single's
    mission, as stated on their website is to help people living with HIV find friendship,
    love and companionship without the fear of disclosure, stigmas or judgment.
    Ein weiterer Inhaltstoff ist nach wissenschaftlichen Arbeitsverfahren
    das 100% natürliche „Garcinia Cambogia" (HCA).

    my page; www.hotelgarden.Abruzzo.it

    ReplyDelete
  4. I'll immediately clutch your rss feed as I can not in finding your e-mail subscription hyperlink or e-newsletter service. Do you have any? Please permit me recognise so that I may just subscribe. Thanks.

    my weblog youtube downloader online

    ReplyDelete
  5. The rig that runs Crysis at 68 FPS will get close to a hundred
    on older or less demanding games. Afterwards, joust your cash chips on the
    cash desk. You can join the millions of people who
    play online bingo.

    My weblog: please click the next website
    Also see my webpage - online spielespielen

    ReplyDelete
  6. Essentially, it is usually drastically more affordable in the event you exchange the actual
    battery oneself, as opposed to finding a storage area to get
    it done. As you lift out the screen you'll see it is still attached via a ribbon cable. Both Intel and AMD contain information built in the processor to allow the processor to be used efficiently with mobile computing saving on battery life while giving the best performance.

    Also visit my weblog ... goldmedalsupplements.com

    ReplyDelete
  7. Hi, I do think this is an excellent site. I stumbledupon it ;) I will revisit yet again since i have
    book-marked it. Money and freedom is the greatest way to change, may you be rich and continue to guide others.


    Also visit my page Comment avoir plus de vues youtube

    ReplyDelete
  8. For some people, renting those games was another option, which yet again burns a hole in their pocket.
    A look into some of the best Star Wars apps to be found on i
    - Tunes, including games, fun soundboards, books, and more.
    The player guides Phen through 10 levels of dungeon gameplay,
    finding a whole host of weapons and other items as well.

    My weblog :: internet radio

    ReplyDelete
  9. You really maκe it seem so eаsy with your presentatіоn however I to find this mattеr
    to be reаlly onе thing whiсh I feеl
    I'd never understand. It kind of feels too complicated and very large for me. I'm looking forωard οn yοur next submit, ӏ'll try to get the hang of it!

    Also visit my web site: review most affordable hotel charges

    ReplyDelete
  10. I'm not sure where you're getting your info, but great topic.

    I neeԁs to spend some time lеaгnіng more or underѕtanding more.
    Thаnks for excellent іnfoгmation I was looking
    for this info for my mіsѕion.

    My weblog - Plan Your own Searching Stay in Dubai Resorts Near Shopping Centre

    ReplyDelete
  11. Pengen yang lebih seru ...
    Ayo kunjungi www.asianbet77.com
    Buktikan sendiri ..

    Real Play = Real Money

    - Bonus Promo Red Card pertandingan manapun .
    - Bonus Mixparlay .
    - Bonus Tangkasnet setiap hari .
    - New Produk Sabung Ayam ( minimal bet sangat ringan ) .
    - Referal 5 + 1 % ( seumur hidup ) .
    - Cash Back up to 10 % .
    - Bonus Royalty Rewards setiap bulan .

    Untuk Informasi lebih jelasnya silahkan hubungi CS kami :
    - YM : op1_asianbet77@yahoo.com
    - EMAIL : melasian77cs@gmail.com
    - WHATSAPP : +63 905 213 7234
    - WECHAT : asianbet_77
    - SMS CENTER : +63 905 209 8162
    - PIN BB : 2B4BB06A / 28339A41

    Salam Admin ,
    asianbet77.com

    Download Disini

    ReplyDelete

Silakan Coment disini

Related Posts with Thumbnails

Artikel Lainnya


ARSIP BLOG
MY MENU
POSTING TERBARU
TUKAR LINK

MEMBER
WEB LINKs
VISITOR