Это видео недоступно.
Сожалеем об этом.
Excel Nested IF Function
HTML-код
- Опубликовано: 20 май 2020
- Learn how to use excel's nested if.
An if formula inside another if formula is called a nested if function
We cover a few examples in this video including:
1. Simple if function ( to check either students is Pass or Fail)
2. Nested if formula (if inside another if) to check for multiple criteria
3. Nested if Examples (for null text string)
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
#innozant #msexcel #mis #excel #advanceexcel
Main apki bhi videos se bahut kuch Sikh Raha hai thanks sir itni ache se har topic ko explain karne ke liye
sir bht deeply smjhaya apne jo bhi dout the sb clear ho gye🤗
excel m expert h aap sir nice video with detail expalnation
Thank u for your kind support and encouragement
You are truly a good teacher .
Thank you for your lectures 🙏
Thanks Abhishek Ji..God bless You❤️
Very clear explained 👌👌
Thanks a lot sir, great explanation😊
You are the best teacher ever. All doubt cleared.
I have seen many vedio of excel but the way teaching of your is excellent. Thanx
Thanks Surender Ji..Happy learning ❤️
Best tutor online
Hello Sir ,
The way to taught everything by simple way it's make so interesting and easy to learn lots of time , I try to learn but ,now get the roots of functional ,
Thank you So much ,,,😊
Thanks Bajaj sahab..Hope you start your learning journey. Recommend you to start from palylist Basic Excel(Videos in sequence Playlist available in video description)
Easy way to learn and explain simple process... Thank u Sir 🙏
Happy New Year 😊
Thanks dear
Nice content and good explanation 👌
Easy way to learn..nice sir
Good sir and great knowledge ❤❤
Informative content..nice sir
Bahut achche se smjhaya sir ap ne
Really i salute sirr🙌 apka smjhaya hua bahut aache se samjh ata hai
Thanks Amit Ji🙏❤️
@@Innozanti also thanks you sir for You Teach Everyone💪💪💪
you are doning great sir
very good explanation
Awesome 👍 guru Ji..
EXCELLENT TEACHER SIR THANK U FOR TEACH
Thank you sir 👍🏻👍🏻
BAHUT ACHI TARAH SE SAMJH AA RAHA HAI SIR.......CRYST & CLEAR
PLS. SHARE & LIKE THE VIDEOS BHAI LOG
Thanks dear .keep learning..keep exploring ❤️
Very informative video Sir
Love you sir yours teaching skills awesome
Thanks ❤️👍
Thank You Sir... Very MUCH..!!!
Thanks dear
Thanks sir .....i want to learn this function
Great explanation
Thanks Sandip Ji🙏❤️
Thank you so much sir.
Kabhi bhi kisi formule me fasta hu sochta hu ghar ja ke 😌Innozant channel 😊pe dekh ke sheekh lunga.(for me one kind of strength ho sir aap excel ke liye)
Thanks Nasim 👍❤️
It was helpful. Thanks! :)
Thanks Garima..Keep learning in sequence step by step and do practice on regular basis.
Practice sheet link is there in video description
Thank you sir
Samjane ka tarikha bhout sahi h ...
Superb
This video cleared my doubts
Thanks
bahot he acha wa sir kiya baat hai aaap ki meri parthana aaap ko bahot dua milege
Thanks Dear❤❤
Hello ,
learning a lot from your videos.
can you kindly share more practices question.
Hi Sushant..Kindly find practice file link available in video Description (Assignment master folder direct link)
Intresting video 😇
Thanks for showing your interest in our channel.Keep learning.
That's great video
nice Explain sir
Love from Pkistan.
Very nice sir
though it was three years ago video but it's an excellent video for those who want to learn nested functions.
Thanks dear .Keep Learning ❤️
TQ...SIR...🙏🙏
thank you Sir ji
Sir apka bahut bahut dhanyawad....... You're magician sir....✌✌✌
Thanks Rahul Ji👍❤️
Thanks
Thq sir🙏
Its applicable vedio😎
Thankyou sir
Wah sir ji .....
Very nice explain sir
thanks rohit ji
well explained
Thanks Siddharth ji
Good evening dear sir, aap itna accha padhate hai, padhne mai bahut intrest aata h, aapka har ek video dekhta hu, excel to maine aap se hi seekhi h, your teching is great....
Thanks Arun ji
Clearly understood. Thank you. But we need more example like if, and formula etc..
Sir, I am saying that out of 6 subjects, the percentage of 3 subjects should be calculated
Sir I understand your every video very well and like it very much. I watch every video of you
सर आप के समझाने का तरीका बहुत ही बढ़िया है और आपके विडियो से बहुत कुछ सीखने को मिलता है ।
धन्यवाद सर
Thanks dear ❤️❤️
ur learning style is very easy. superb sir, aapse vba shikhana hai
Thanks Pankaj Ji ♥️
Amazing
Thanks you sir ji excel ko sequence me sikhane ke liye bahut log RUclips pr excel ke video banate hai but sequence me nhi wo log y.t. growth kr rahe hai hum sab aapke saat hai jaldi hi apka channel or innozant family bahut aage jayegi
Thanks Nirmal,Keep learning.Keep Exploring ❤️👍
Excellent 👌👍
Hi Sir, if some column have specific text in meddle and we want any specific text against that middle text. Could you please help on this. ?
Weldone sir
Sir. Hope you will be fine. Your 2years ago uploaded tutorial upon nestedif I had saw . Sir please upload a tutorial upon hours calculation . I will thankful to you.🌹
RUclips ne ye channel mujhe phle suggest kyu nhi kiya itna knowledgeable content or vo bhi free mein.
Thanks dear...God bless You
level ha sir ap ka
Thanks dear❤️🙏
Thank you very much. i stay in UAE and want to learn if function with lots of criteria. These criterias are from different cells .
nice Explain sir👌🏻👌🏻👍🏻👍🏻
Thanks Karan for your valuable feedback and showing your interest in our Advance excel training videos.
Nice sir
super👌👌
Which function can use it if() already used but power query getting very slow performance wise
need more examples also about AND function
tq sir
Thnq sir
Sir nexted if formula me jo condition diya jata he wo har waqt lower se higher hoga na.. like 1st
Sir how to use this for match of partial text matters
Hi Sir
Need question samples for if and nested if..
Osam sir
Sir first of all thanks for your all educational videos you are amazing teach Excel and other topics , thanks again....but sir meri ek query hai if kisi ke marks kisi subject me kam aaye hai to hum usko minimum function se show kar sakte hai but itne saare logo me kiske marks or kis subject me subse kam number hai weh hum kaise nika lenge please sir solve my this problem.....
How to indicate that person and his subject.. please sir solve this.......and again thanks for interesting teaching..... 🙏🙏🙏🙏🙏🙏
Nice
Aagya sir smjh me thnx " NAaRIYAL CHILL DIYA PURA"😁 THNX SIR for this content....
Thanks 😃😃😀
Bahut badhiya hai sir thoda joom karke bataye sir formula saf nahi dikhta hai. Samjhane ka tarika v apka The best hai sir 👍👍👍👌👌
Thanks.mmye old videos h dear ..ab zoom ka issue ni hai latest videos me
SIR MACRO KA VIDEO SHARE KARO ... GREAT WORK .. PROBABLY BEST IN EXCEL SERIES ...
Sure dear..you may abow to see complete tutorial ..but need some time as m uoloading power query and power bi these days
Thanku sr mujhe v fir s padhane k liye
Good morning sir i watch always your videos and learn many things but sir please i want to use if formula with more example
Sure dearmyou may watch our Google sheets playlist as well
nice
sir
Thanks Sabuj❤️🙏
Want to know how to retrieve certain value for random fluctuating column and row
Hi Shradha ,Kindly explain your query in detail dear..Will guide you for the same.
Pls send more examples for nested if function
=IF(LEN(I4)-LEN(SUBSTITUTE(I4,",",""))=0,IF(N(ISNUMBER(FIND(I4,G4))),"Match","No Match"),IF(LEN(I4)-LEN(SUBSTITUTE(I4,",",""))=1,IF(AND(ISNUMBER(SEARCH(LEFT(I4,FIND(",",I4)-1),G4)),ISNUMBER(SEARCH(RIGHT(I4,LEN(I4)-FIND(",",I4)-1),G4))),"Match","No Match"),IF(LEN(I4)-LEN(SUBSTITUTE(I4,",",""))=2,IF(AND(ISNUMBER(SEARCH(LEFT(I4,FIND(",",I4)-1),G4)),ISNUMBER(SEARCH(RIGHT(I4,LEN(I4)-FIND(",",I4,FIND(",",I4)+1)-1),G4)),ISNUMBER(SEARCH(MID(I4,FIND(",",I4)+2,FIND(",",I4,FIND(",",I4)+1)-(FIND(",",I4)+2)),G4))),"Match","No Match"),IF(LEN(I4)-LEN(SUBSTITUTE(I4,",",""))=3,IF(AND(ISNUMBER(SEARCH(LEFT(I4,FIND(",",I4)-1),G4)),ISNUMBER(SEARCH(MID(I4,FIND(",",I4,FIND(",",I4)+1)+2,FIND(",",I4,FIND(",",I4,FIND(",",I4)+1)+1)-FIND(",",I4,FIND(",",I4)+1)-2),G4)),ISNUMBER(SEARCH(MID(I4,FIND(",",I4,FIND(",",I4))+2,FIND(",",I4,FIND(",",I4)+1)-FIND(",",I4)-2),G4)),ISNUMBER(SEARCH(RIGHT(I4,LEN(I4)-FIND(",",I4,FIND(",",I4,FIND(",",I4)+1)+1)-1),G4))),"Match","No Match")))))
Hello Sir,
I have a large data file which contains extra line with the help of alt÷enter in a column in excel. how to delete the same
Hello Sir
I watch your videos and learn many things
But u have query for IF function
How to use IF(AND(OR with vlookup
Thanks, brother, Regularly I am watching and learning. But I am not found Ifs formula. What is the differences between ifs and nested if formula.
Ifs is very simple dear as we are using this function instead of nested if and it is available in office version 2016 onwards.
In IFS function we start with single parenthesis and close it with single one and there is no need to paas multiple of inside if as we are passing in nested if function.
Eg IFS( LOGIC1,RESULT1,LOGIC2,RESULT 2....)
Sir i have Expenditure statement monthly wise like (Current+previous=Total) problem is that when i make copy of this sheet and make new Month sheet so i make it manually copy column of total and paste it to new sheet of previous.
Sir want How it is possible to make automatically when i create copy of this sheet kindly let me know Thanx.
Sir I want information about nested if pls clarify this topic
Video se samjh nhi aaya kya nested if aapko?
sir preparing for MIs , I think there is videos series missing of chart , have you posted or not yet ??
Chart series already started
❤️
Sir, can I get assignments to parctice with data sets?
Yes data set is there , Kindky download assignment master from video description
👍
Please share an example with IFS function, if an example has an blank cell
Sir paragraph likhne k bad cursor upr kaise le k ja skte hi
Ab samajh aaye
Ye wala topic
GREAT SIR PLEASE PROVIDE ME ASSIGNMENTS FOR PRECTICE ITS A HUMBLE REQUEST SIR
Practice fole video description me link diya hai wahan se download kar lijiye saare playlist ke hain assignment
can I get some sheets for if and ifs function?
Hi Shruti,Please find assignment file in video Description (Download Link are there)