Tutorial Excel kali ini mengenai menghilangkan #N/A. Apabila kita menggunakan fungsi Vlookup atau Hlookup kita pasti akan menemukan hasil #N/A apabila referensi yang kita cari tidak menemukan data yang sesuai dan hal ini tentu akan membuat tampilan data kita menjadi kurang enak dilihat apabila kita tidak menghapusnya, namun apabila kita harus menghapus #N/A tersebut kita juga akan sedikit repot kalau data kita cukup banyak.
Nah untuk menghapus #N/A tersebut Belajar Komputer Melalui Internet Kali ini akan share yaitu dengan menggunakan bantuan fungsi IsNA, dimana fungsi Vlookup atau Hlookup akan kita gabungkan dengan IsNa ini menggunakan bantuan fungsi IF.
Berikut lengkapnya:
Buat data tabel seperti berikut:
data diatas adalah data pembelian pada bulan januari dan pebruari selanjutnya kita kemudian kita buat data rekapitulasi data diatas seperti berikut:
Data Pengeluaran sebelah kiri pada kolom bulan Cell No 1 sampai No 6 Masukan Fungsi Vlookup lihat cara membuat fungsi Vlookup Ms. Excel. hasilnya pada cell nomor 5 dan 6 akan #N/A karena Bolpoint dan Spidol tidak terdapat pada data pembelian di bulan Januari.
Agar tidak menghasilkan #N/A maka sebaiknya kita menggunakan fungsi sebagai berikut:
=IF(ISNA(VLOOKUP(H22;$B$4:$E$10;4;FALSE));"";VLOOKUP(H22;$B$4:$E$10;4;FALSE))Penjelasan:
Fungsi IF(Kondisi,JikaBenar,JikaSalah).
Jika kondisi
rumus Vlookup() nilainya #N/A, tampilkan nilai kosong ("") jika tidak
maka tampilkan hasil rumus VLOOKUP(A7,daftar,2,FALSE)
Mungkin sampai disini dulu Belajar Komputer Melalui Internet tentang Cara Menghilangkan #N/A pada fungsi Vlookup Excel kali ini, semoga bermanfaat bagi Anda.
DAPATKAN ARTIKEL VIA EMAIL
Dipublish oleh :
Abdul Kohar - Jatinangor Rating 5
Wah baru ketemu nih cara bikin dan format EXCEL...Thanks Ya
BalasHapustx ilmunya, tapi kok BELUM BISA ya... what wrong?
BalasHapusmungkin salah penulisan tabel aray atau cool indexnya sobat
HapusWihhh mantap.. infonya berguna banget.. tq
BalasHapus:!!
BalasHapus=))
Bagus mas triknya
BalasHapusDapet PR dari SPV aku tentang ini, and I did It 😀 thanks ya Pak
BalasHapusThank for sharing
BalasHapusObat kutil kelamin
Obat Wasir
De Nature Indonesia
Cara Mengobati Wasir
Obat kutil kelamin ampuh
Obat Sipilis
Obat Gonore
Obat Herpes
De Nature
artikel yang sangat bermanfaat gan..... saya senang berkunjung ke blog anda.... terimakasih teruslah memberikan informasi yang bermanfaat gan....;)
BalasHapusterimakasih atas tutorialnya, semoga bisa di aplikasikan, saran saja bagaimana kalau tutorialnya di format menggunakan video pasti lebih mudah di pahami
BalasHapusThanks for sharing
BalasHapusNice info
BalasHapusThanks for sharing, I feel about it and love learning more on this topic.
BalasHapusObat Kutil Kelamin Manjur
Obat Kutil Kelamin Wanita Alami
Obat Kutil Kelamin Pria
Obat Sipilis
BalasHapusObat Sipilis Ampuh
Obat Kencing Nanah
Obat Raja Singa
Cara Mengobati Sipilis
Obat Sipilis di Apotik
Dak bisa jalan
BalasHapus,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
your article is very nice
BalasHapusagen judi online indonesia
your article is very nice
BalasHapussbobet live betting
mantap gan
BalasHapusterima kasih atas informasinya
Cerita Dewasa
Cerita Hot
Cerita Sex
Film Semi
Cerita Dewasa
Cerita Sex Terbaru
Cerita Sex
Film Semi
Situs Judi Online
Judi Online
Agen Bola
Agen Casino Online
Togel Online HOKIBET
very good discussion for my insights, such as information about Beli Obat Herbal KutilObat Tradisional Kutil KemaluanHarga Obat Kutil DenatureGambar Kutil KelaminGejala Jengger ayamObat Herbal Jengger Ayam
BalasHapusObat Asam Urat
BalasHapusObat Asam Urat Alami
Obat Asam Urat Dan Kolesterol
Obat sipilis
Obat gonore
Obat Asam Urat
BalasHapusObat Asam Urat Alami
Obat Asam Urat Dan Kolesterol
Obat sipilis
Obat gonore
Good jobs article
BalasHapusObat Aborsi
Jual Obat Aborsi
Obat Aborsi Jogja
Obat Peluntur
Obat Aborsi Ampuh
Obat Aborsi Surabaya
Pusat Obat Aborsi
Obat Aborsi Bandung
Thank you for giving us the knowledge of what you have described. do not forget to visit our website :
BalasHapusJudi Online Indonesia
Nonton Movie Online
Film Bioskop Streaming
Pokerboya
Judi Bandar Ceme
Domino Online
Agen Poker Online
Nonton Film
siip semoga post berguna
BalasHapus
BalasHapusVery nice the article
http://www.ahlinyaobatasamlambung.com/pengobatan-penyakit-amandel-dengan-harga-terjangkau/
http://www.ahlinyaobatasamlambung.com/pengobatan-untuk-mengatasi-penyakit-darah-tinggi-hypertensi-secara-alami/
http://www.ahlinyaobatasamlambung.com/cara-mudah-dan-tepat-mengobati-stroke-secara-alami/
http://www.ahlinyaobatasamlambung.com/obat-sakit-diare-pengobatan-penyakit-diare-alamiaman-tanpa-efek-samping/
http://www.ahlinyaobatasamlambung.com/cara-menghilangkan-jerawat-dengan-bahan-alami-aman-tanpa-efek-samping/
Thanks dear For your Nice Post . It's Was Amazing! Friend I have Blog About Microsoft office setup .
BalasHapusIf anyone interested to setup office please Visit My Blog. I will be apprised.
shor discription About my blog here :
office.com/setup : At the point when we are working or
serve the client just one in our mind that is "Consumer loyalty". We think each agents believing resembles as we have and
we are continually hoping to improve our capacity to address the issue of our customers.
We have huge number of trucks and other development gear to take the necessary steps in a great way and our trustworthiness, workplace and advancement to take the organization on high.
At the point when each client really fulfilled , then individuals says that is the privilege choice.For More : office.com/setup
\ Microsoft office setup
Best Regards
Microsoft office setup | www.office.com/setup |
norton.com/setup | Buy Google Voice Account | office.com/setup
Thanks for all the tips mentioned in this article! it???s always good to read things you have heard before and are implementing, but from a different perspective, always pick up some extra bits of information. Visit@:- mcafee.com/activate | norton.com/setup | mcafee.com/activate | office.com/setup | adviser for you
BalasHapus
BalasHapusDragon Naturally Nuance Dragon Legal Individual speech recognition software
dragon naturally speaking | dragon naturallyspeaking | nuance dragon | nuance dragon naturallyspeaking | naturally speaking
Nice Post
BalasHapusBeautiful Places To Explore In California
Amazing Things That Can Do In South Africa
Best Things That Can Do In Italy
I really happy found this website eventually. Really informative and inoperative, Thanks for the post and effort! Please keep sharing more such blog.
BalasHapusnorton.com/setup
spectrum email login
kaspersky activation
steps to install and setup ms office on pc
BalasHapuswww.office.com/setup,
office.com/setup,
www.office.com/setup,
office setup,
office.com/setup
Microsoft Office is the best application launched by the microsoft application. If you want to download and setup ms office then visit: www.office.com/setup, office.com/setup, ms office setup, office setup, office 365 setup or enter product key ms office,
BalasHapuswww.office.com/setup, office.com/setup, ms office setup, office setup, office 365 setup or enter product key ms office,
www.hulu.com/activate, hulu.com/activate, hulu activate hulu com activate , hulu.com activate, hulu activation code
www.hulu.com/activate, hulu.com/activate, hulu activate hulu com activate , hulu.com activate, hulu activation code
McAfee Antivirus Tools are developed by Symantec Corporation, provides a complete Anti-Virus suite for PCs.o to your McAfee Antivirus software and Open it. · Enter the 25 digits alpha-numeric product key that was mailed to you
BalasHapuswww.mcafee.com/activate
mcafee.com.com/activate"
<a href="https://mcafee-activation.com/>mcafee activation</a>
"Thankyou for sharing the wonderful post and all the best for your future. I hope to see more post from you. I am satisfied with the arrangement of your post.
BalasHapusYou are really a talented person I have ever seen
aol email login| aol email login|
netgearrouterlogin|facebooksignin|
gmail not working|comcastemaillogin|
roadrunneremaillogin|
aol email login|
paypallogin||aol email login||
yahoo maillogin||yahoo maillogin|
quickbooks online login||
intuit quickbooks login||
amazoncompromocode"
görüntülü show
BalasHapusücretlishow
ORİVOR