Excel Nested IF Function
HTML-код
- Опубликовано: 21 сен 2024
- 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.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
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/innozanti...
#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
I have seen many vedio of excel but the way teaching of your is excellent. Thanx
Thanks Surender Ji..Happy learning ❤️
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 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 👍❤️
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
सर आप के समझाने का तरीका बहुत ही बढ़िया है और आपके विडियो से बहुत कुछ सीखने को मिलता है ।
धन्यवाद सर
Thanks dear ❤️❤️
RUclips ne ye channel mujhe phle suggest kyu nhi kiya itna knowledgeable content or vo bhi free mein.
Thanks dear...God bless You
bahot he acha wa sir kiya baat hai aaap ki meri parthana aaap ko bahot dua milege
Thanks Dear❤❤
You are truly a good teacher .
Thank you for your lectures 🙏
Thanks Abhishek Ji..God bless You❤️
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 the best teacher ever. All doubt cleared.
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
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 ❤️👍
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
BAHUT ACHI TARAH SE SAMJH AA RAHA HAI SIR.......CRYST & CLEAR
PLS. SHARE & LIKE THE VIDEOS BHAI LOG
Thanks dear .keep learning..keep exploring ❤️
Thank u for your kind support and encouragement
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 ❤️
Good sir and great knowledge ❤❤
Thank you very much. i stay in UAE and want to learn if function with lots of criteria. These criterias are from different cells .
Easy way to learn..nice sir
Great explanation
Thanks Sandip Ji🙏❤️
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..... 🙏🙏🙏🙏🙏🙏
Thanks sir .....i want to learn this function
Thank You Sir... Very MUCH..!!!
Thanks dear
Very clear explained 👌👌
Easy way to learn and explain simple process... Thank u Sir 🙏
Happy New Year 😊
Thanks dear
Which function can use it if() already used but power query getting very slow performance wise
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
Bahut achche se smjhaya sir ap ne
Sir apka bahut bahut dhanyawad....... You're magician sir....✌✌✌
Thanks Rahul Ji👍❤️
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
you are doning great sir
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
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.🌹
Informative content..nice sir
Thanks a lot sir, great explanation😊
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)
Please share an example with IFS function, if an example has an blank cell
Love you sir yours teaching skills awesome
Thanks ❤️👍
Sir I want information about nested if pls clarify this topic
Video se samjh nhi aaya kya nested if aapko?
Love from Pkistan.
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.
Superb
This video cleared my doubts
Thanks
Thank you sir 👍🏻👍🏻
ur learning style is very easy. superb sir, aapse vba shikhana hai
Thanks Pankaj Ji ♥️
Best tutor online
Very nice explain sir
thanks rohit ji
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")))))
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
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.
Aagya sir smjh me thnx " NAaRIYAL CHILL DIYA PURA"😁 THNX SIR for this content....
Thanks 😃😃😀
EXCELLENT TEACHER SIR THANK U FOR TEACH
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....)
need more examples also about AND function
I have used multiple if function but it is not working kindly resolve th problem
Samjane ka tarikha bhout sahi h ...
Sir paragraph likhne k bad cursor upr kaise le k ja skte hi
Sir,Ap ye Bataye k Kisi bhi function ko kab,kese aur Q combined kerte hain ye logic bataye?
Sir excel me ek formula batana jiski conditions ye hai ki Total marks par grading deni hai aur each minimum marks ho. Jaise Hindi me minimum 33, English me 40 , Math 30 ho
Sir how to use this for match of partial text matters
Thank you sir😊
Sir, If First Column Value 0 & Next Column Value 1 then Third column 0 how to possible in formula please confirm formula
Sir Diferent product ke diferent scheme hai to isme kaun si formula use hogi
P-1 Qty 0to10 scheme Rs 5 11to20 scheme Rs. 15
P-2 Qty 0to20 scheme Rs. 8 21to35 scheme Rs. 15
For what formula work in this case
Sir nested if ka aur complicated exercise karvayie.
Nice content and good explanation 👌
Sir mere 2007 version h isme nestedif ka formula satik nhi baitha rha h, aour 2sra request h ki please ydi ho ske to to practice set provide kr dijie
Sir nexted if formula me jo condition diya jata he wo har waqt lower se higher hoga na.. like 1st
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)
nice Explain sir
Very nice sir
I'm not able to understand next which formula i have to apply. Means mai IF function use karra hu uske baad AND formula use karu ya AND formula
Sir Mis ke liye starting sain end tak step by step 2/4 video banao taki hum ko interview main problem naa aaye
Bht saare videos Bane hue hain.kindly learn
Hi Sir,
I have started again revision but below query is not find out completely result. Can you suggest please whyy?
=If(OR(C6,D6)="","",C6*D6)
CAN YOU HELP ME HOW TO SHOW THE FOLLOWING GIVEN BELOW;
8:15AM TO 8:30AM MENTION -1HOUR,
8:31 TO 9:00 MENTION -2HOUR,
9:01 MENTION -4HOURS,
12:00PM MENTION -4HOURS,
3:00PM MENTION -2HOURS,
4:00 PM MENTION -1HOURS ALL THIS IN ONE CELL IS THERE A WAY?
Sir, how can I send you the picture? I don't feel like asking this question about my work
Right same situation
Sir, give us your email ID
Model No. Segment
HEXA Large
ALTR02 small
SAFARI Large
SAFARI Large
HARRIER Large
ALTR02 small
TIAGO small
SAFARI Large
NEXON Medium
I need help in this as I want in next cell if I'll type Hexa result come in Large
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
very good explanation
Sir 3 cells me agar OK word hai to result OK aaye agar ek men No ho to Not Ok aaye .ye formula btaye
7:28. Second solution
=IF(OR(price="",Qty=""),"",price*qty)
Note mere excel teacher KO agar excel maharaja series par baitha diya jai to Agra ka pagal khane me jayengi dimag damage hoga uska same jatadhari jaise hain 🤣😂😂🤣😂😂 really really thank Sir 🙏🏻🌻❤🙏🏻
Didnt get you,kindly share your query..?
your video is good but unable to find practice file in assignment master folder . pl upload file separate in video description
Seprate link is broken..We will store it soon Meanwhile you may download assignment master link folde for all playlist assignment
Very informative video Sir
Thank you sir
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. ?
Hii . Sir jee dekhiye to.. Aisa kuch kiya ja sakta hi kya..
>40% to 50% - C2
>50% to 60%- C1
>60% to 70%- B2
>70% to 80% -B1
>80% to 90% - A2
>90% - A1
thank you Sir ji
Pdf jaise ki 40 page ki ho use manual excil sheet kaise bnaye km same main kab net se convert na hoti ho file
Sir I need answer of this question - where Login time is 08:00 than show the "login on time after 08:00 login than show the late login where L than show the leave and WO show the WOP i have created this formula but unable to get correct ans. please help me sir
8:00
8:15
8:05
8:00
8:20
8:02
WO
WO
8:00
8:05
L
L
L
8:00
8:01
=IF(F11=08:00,"Late login",IF(F11=WO,"WOP","Leave")))
First of All
Assalamu Alikum Sir
Sir I want some assignment related this function.
This formula uses more levels of nesting to kya karain??
well explained
Thanks Siddharth ji
Sir iska data entry me kya use hai
Please tell me😊
As office assistant bhi kaam krenge tab bhi ye basic functions to aana hi chahiye dear
Sir kindly mujy btayn k mujy Conditional formatting k sath if btayn k Agar meri sys qty=Diff tw Ok otherwise counting mistake
Sir mujhe 1 lookup value se 2 columns fetch karane hai. I mean mere pass 3 columns hai Screen 19inch, 22inch aur 24 inch aur 1 hi lookup value se 2 screen fetch karani hai, matlab 3 screen main se 2 main data hoga kisi bhi column main ho sakta hai to kaise fetch karenge. 1 ID se kaise 2 screen fetch karenge. Kisi main screen 19inch main hoga kisi main screen 22inch main aur kisi main screen 24inch main hoga matlab 2 main data jarur hoga. Jisme data ho usko show karaye
Awesome 👍 guru Ji..
Hallo Sir Nested IF Key Assignments mil Shakta Hai
Sir,
I didn't understand. how can i know ?
Thanks
Sir nested if tutorial tak kain assignment kindly bhej saktain hain