Excel - IFERROR Function | How to use IFERROR formula in excel | Hindi

  Рет қаралды 41,766

Innozant

Innozant

4 жыл бұрын

How to use IFERROR formula function in excel HINDI
IFERROR is amzing and very useful formula while you are working with excel formulas and if formula expression is an error like #div/0 #value #name #ref #NA etc then there is a great role of Iferror function.
IFERROR formula in excel 2007 2010 2013 & 2016 is very much useful as we we can set any custom message to show in place of Error message.
1. Learn how to use the iferror function for your formulas in Excel
2. How to use iferror function to remove errors.
3. Iferror with vlookup
Basic Excel Playlist Link- • Basic Excel-The Learni...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#iferror #iferrorfunction #Innozant #Exceltutorial #exceltips #iferrorformula

Пікірлер: 107
@mohdfaraz7877
@mohdfaraz7877 2 жыл бұрын
now my problem solved..thank u for making this video...
@taranggraphix2178
@taranggraphix2178 2 жыл бұрын
Sir app bahut acccha samjhate hai Ek hi bar me samajh aa jata hai
@muhammadasif-gw2kc
@muhammadasif-gw2kc 6 ай бұрын
Good video Sir, we usually get NA when we use v look up, Thanks for your guidance
@shahzadsiddiqui5117
@shahzadsiddiqui5117 Жыл бұрын
so jolley mood when you teach..:) and that line "doorbin lekr dhundu" was epic...!
@Innozant
@Innozant Жыл бұрын
Hahahaha.Thanks dear.Happy Learning ❤️
@aishwaryaambasta7013
@aishwaryaambasta7013 4 жыл бұрын
Very useful function..sir
@rojiswain8729
@rojiswain8729 Жыл бұрын
Sir great job 👍👍
@premchandsagar157
@premchandsagar157 2 жыл бұрын
Thank you sir❤️
@koustavbabu
@koustavbabu Жыл бұрын
Love u Sir. 🙏🙏🙏
@hanzalaufc8055
@hanzalaufc8055 2 жыл бұрын
Good explanation
@AjayGupta12345.
@AjayGupta12345. 10 ай бұрын
Great sir...
@nalinas2715
@nalinas2715 2 жыл бұрын
sir you are awesome.... the basic explanations makes the concept under completelt and you are superb i n it
@Innozant
@Innozant 2 жыл бұрын
Thanks Nalina..Happy learning ❤️
@tarunmahanta5101
@tarunmahanta5101 2 жыл бұрын
The way u teach... If people follow u. They wl definitely learn something and never forget. Good luck
@Innozant
@Innozant 2 жыл бұрын
Thanks Tarun ji
@NomanAli-rl2nr
@NomanAli-rl2nr Жыл бұрын
Great sir g❤️❤️❤️
@sparkingbulls..1847
@sparkingbulls..1847 2 жыл бұрын
SIR U ARE AMAZAING NO ONE IN KZbin GIVE CONTENT LIKE U.. SUPERB SIR SUPERB ........
@Innozant
@Innozant 2 жыл бұрын
Thanks Bajpayee sahab..God Bless You dear..Never stop learning ❤️
@RA-rh5lb
@RA-rh5lb Жыл бұрын
badiya Sir ji ..
@Altaf_Alam
@Altaf_Alam Жыл бұрын
Good morning sir ❤️
@farhanilyas12
@farhanilyas12 Жыл бұрын
Thanks Sir
@sadashivkage3133
@sadashivkage3133 Жыл бұрын
TQ..SIR..🙏🙏
@hemukosuru5286
@hemukosuru5286 4 жыл бұрын
Use full...tq sir
@Innozant
@Innozant 4 жыл бұрын
Thanks Dear,Hope you learn from our video, Recommend you to start learning Step by Step from Basic Excel playlist
@Washaista
@Washaista 3 жыл бұрын
Good teaching style . well done sir , keep it up
@Innozant
@Innozant 3 жыл бұрын
Thanks dear..Happy learning 🙏❤️
@suvankarbasu4890
@suvankarbasu4890 11 ай бұрын
You are doing great job sir.i have learnt a lot from you on adavance Excel and save lot of money because there are some institution who ask lot of money for this.... Thanks sir.
@Innozant
@Innozant 11 ай бұрын
Thanks dear..God bless You..Keep Learning
@AlimKhan-bl5sh
@AlimKhan-bl5sh 4 ай бұрын
Sir mene to dhiyaan nahii diya ku k MIS se pehle mene.. Vlookup series sikh liya tha isliye mujhe to samajh me aya😀..
@anushreeshah9239
@anushreeshah9239 3 жыл бұрын
Thank you Sir🙏🏻
@Innozant
@Innozant 3 жыл бұрын
Thanks Anushree..Have a great career ahead❤️
@UncuttReview
@UncuttReview Жыл бұрын
Thanks sir Aap bahut accha explain karte ho
@Innozant
@Innozant Жыл бұрын
Thanks dear
@user-cb7bb7jq3o
@user-cb7bb7jq3o 2 жыл бұрын
Love u bro ❤❤all Video Nice
@Innozant
@Innozant 2 жыл бұрын
Thanks dear❤️
@dnyaneshwarsai9754
@dnyaneshwarsai9754 11 ай бұрын
thank 🥰
@reetaarya5193
@reetaarya5193 Жыл бұрын
Amazing 👍
@Innozant
@Innozant Жыл бұрын
Thanks Reeta..Keep Learning ♥️
@Armankhan_78661
@Armankhan_78661 Жыл бұрын
Brilliant sir thank Allots
@Innozant
@Innozant Жыл бұрын
Thanks Arman
@ketansubha8170
@ketansubha8170 2 жыл бұрын
Excellent sir
@Innozant
@Innozant 2 жыл бұрын
Thanks Ketan Ji
@rahulrakshe1988
@rahulrakshe1988 2 жыл бұрын
Nice teach
@gauravbhatia7987
@gauravbhatia7987 3 жыл бұрын
Good sir
@dhakafady774
@dhakafady774 7 ай бұрын
sir please please give some more videos about power BI and DAX
@rohitadlakha2838
@rohitadlakha2838 4 ай бұрын
Nice
@RanveerSingh-eo6pt
@RanveerSingh-eo6pt 2 жыл бұрын
Good
@hemukosuru5286
@hemukosuru5286 4 жыл бұрын
Super
@Innozant
@Innozant 4 жыл бұрын
Thanks.Start Learning Step by Step from Basic Playlist 1st Video.
@shailendramishra3456
@shailendramishra3456 3 жыл бұрын
Wow
@Innozant
@Innozant 3 жыл бұрын
Thanks Mishra Ji👍❤️
@harindersingh-sc2wb
@harindersingh-sc2wb 11 ай бұрын
Try to add i Button in those videos which Previous part you have already made, it helps to watch sequence wise videos, for example - I am trying to find your tutorial video for occurance of count if but unable to find the related videos
@Innozant
@Innozant 11 ай бұрын
Kindly watch playlist in sequence
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards power BI and DAX please please sir
@MushtaqAhmad-of5fu
@MushtaqAhmad-of5fu 2 жыл бұрын
sir, After using IFERROR(C5/B5,"") in column D , cells showing blank how to count these blank cell
@rajputtechbar8498
@rajputtechbar8498 2 жыл бұрын
Sir please baare eske baare me
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@DEADYBOYS
@DEADYBOYS Жыл бұрын
Sir ji isme goto special se bhi kr sakte hai
@Innozant
@Innozant Жыл бұрын
👍
@sseshugiri1316
@sseshugiri1316 2 жыл бұрын
My question is, I using sharing formula and wanted to drag below for total month, in formula month with row name(alphabets), D5-(D5*4/100) -APRIL! D19 is the formula, if I drag bottom should come as D6-(D6*4/100) -APRIL! E19, pl revert with explanation
@ManishKumar-se8fi
@ManishKumar-se8fi 2 жыл бұрын
Sir aap offline se bhi achha online padha rahe hai
@Innozant
@Innozant 2 жыл бұрын
Thanks Manish ji..apke ye words bht eham hain dear ❤️
@babai9277
@babai9277 7 ай бұрын
Sir Excel basic to advance playlist create kar do please
@Innozant
@Innozant 7 ай бұрын
Dear..aap ek baar playlist aur video ke description me jaake dekhiye..saare playlist in sequence created hain woth examples
@babai9277
@babai9277 7 ай бұрын
@@Innozant okay Sir Ji 💖💪
@shaalam2096
@shaalam2096 3 жыл бұрын
Sir Power BI and Tableau kya different hai ?, maine u tube p search kiya usme normal different bta rha hai.
@Innozant
@Innozant 3 жыл бұрын
Both are data visualization tool..Wo company par depend ki kya use karte Hain.👍
@ChandanKumar-sq6jn
@ChandanKumar-sq6jn Жыл бұрын
Bhaiya Namaste, Bhaiya My name is Chandan Kumar, from Bihar (Darbhanga). Bhaiya mai Delhi me 3 years se Account department me job kar rha hun, but mai ab apna job switch karna chahta hun, mai MIS executive ban na chahta hun. Mujhe aapse offline class lena chahta hun. Mai aapse kaise connect kar sakta hun plz mujhe guide kijiye. 🙏
@pawanverma7220
@pawanverma7220 3 жыл бұрын
Sir Transpose Formula Mai Extra Part Ko Select Karke Apply Karne Par #N/A show karta hai, If error se bhi nahi hua,
@Innozant
@Innozant 3 жыл бұрын
baharr isna pass karke use null se replace kar dijiye dear
@ayeshachaurasia
@ayeshachaurasia Жыл бұрын
Sir some of your videos got blurred please check and re-upload it again
@Innozant
@Innozant Жыл бұрын
Ok..Tanu..will check it
@Pooja-bd7zm
@Pooja-bd7zm 3 жыл бұрын
Sir IFERROR per or vedio bnao othar formulas ke sath plzzz🙏🙏🙏🙏
@Innozant
@Innozant 3 жыл бұрын
Ok .Pooja .Waise aapko iferror ke video bht milenge lookup swries me dear.🙏❤️
@Pooja-bd7zm
@Pooja-bd7zm 3 жыл бұрын
@@Innozant ok sir thanku
@neerubisht366
@neerubisht366 Жыл бұрын
How can I ask my doubts ? Do you have Email I.D or something so that I reach you ?
@Innozant
@Innozant Жыл бұрын
Hi Neeru Kindly share your query @innozantofficial telegram id
@sunil.blogger6789
@sunil.blogger6789 2 ай бұрын
abe chat kyu kr rha sidha sidha bol na
@Innozant
@Innozant 2 ай бұрын
Great Respect for Teacher👍God bless you
@ASHISHSHARMA-mt4nj
@ASHISHSHARMA-mt4nj Жыл бұрын
=IF([@[task_type]="pickup",[@supplier_id],[customer_id]]) - why this is not working? can anyone help me pls.
@dhakafady774
@dhakafady774 7 ай бұрын
sir please please give some more videos about power BI and DAX
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards power BI and DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
sir please please give some more videos about power BI and DAX
@dhakafady774
@dhakafady774 7 ай бұрын
sir please please give some more videos about power BI and DAX
@dhakafady774
@dhakafady774 7 ай бұрын
sir please please give some more videos about power BI and DAX
@dhakafady774
@dhakafady774 7 ай бұрын
sir please please give some more videos about power BI and DAX
@dhakafady774
@dhakafady774 7 ай бұрын
sir please please give some more videos about power BI and DAX
@dhakafady774
@dhakafady774 7 ай бұрын
sir please please give some more videos about power BI and DAX
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards power BI and DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards power BI and DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
@dhakafady774
@dhakafady774 7 ай бұрын
Sir, please give proper lesson regards DAX please please sir
Excel Sumif Function | Sumifs formula in excel in hindi
11:25
Innozant
Рет қаралды 202 М.
How to use IFERROR formula in excel || HINDI
13:03
Deepak EduWorld
Рет қаралды 213 М.
Gym belt !! 😂😂  @kauermtt
00:10
Tibo InShape
Рет қаралды 17 МЛН
Mama vs Son vs Daddy 😭🤣
00:13
DADDYSON SHOW
Рет қаралды 45 МЛН
IQ Level: 10000
00:10
Younes Zarou
Рет қаралды 8 МЛН
Jumping off balcony pulls her tooth! 🫣🦷
01:00
Justin Flom
Рет қаралды 21 МЛН
Google Sheets IFERROR & IFNA Function
11:29
Innozant
Рет қаралды 9 М.
SURPRISING Sumifs Trick in Excel | SUMIFS Function Hindi
12:46
IFERROR Function in Excel with VLOOKUP | Advance Excel Trick
5:36
Veer Tutorial
Рет қаралды 49 М.
Why You Should Use Excel IFS Function -  Don't Use Nested IF
11:23
Deepak EduWorld
Рет қаралды 202 М.
Gym belt !! 😂😂  @kauermtt
00:10
Tibo InShape
Рет қаралды 17 МЛН