Excel Nested IF Function

[@SanjayShrivastva-cm3wn]

Main apki bhi videos se bahut kuch Sikh Raha hai thanks sir itni ache se har topic ko explain karne ke liye

[@ssk9756]

I have seen many vedio of excel but the way teaching of your is excellent. Thanx

[@Innozant]

Thanks Surender Ji..Happy learning ❤️

[@khushbookamat9337]

sir bht deeply smjhaya apne jo bhi dout the sb clear ho gye🤗

[@cherrypieofficial4969]

excel m expert h aap sir nice video with detail expalnation

[@abhishekparte5524]

You are truly a good teacher . Thank you for your lectures 🙏

[@Innozant]

Thanks Abhishek Ji..God bless You❤️

[@cartoonloversop6019]

सर आप के समझाने का तरीका बहुत ही बढ़िया है और आपके विडियो से बहुत कुछ सीखने को मिलता है । धन्यवाद सर

[@Innozant]

Thanks dear ❤️❤️

[@kkrcreationstatus6583]

BAHUT ACHI TARAH SE SAMJH AA RAHA HAI SIR.......CRYST & CLEAR PLS. SHARE & LIKE THE VIDEOS BHAI LOG

[@Innozant]

Thanks dear .keep learning..keep exploring ❤️

[@Knowledge-wf2vw]

You are the best teacher ever. All doubt cleared.

[@rahulviz8559]

Sir apka bahut bahut dhanyawad....... You're magician sir....✌✌✌

[@Innozant]

Thanks Rahul Ji👍❤️

[@atulgoodify]

Thank u for your kind support and encouragement

[@DEADYBOYS]

Thanks you sir ji excel ko sequence me sikhane ke liye bahut log KZbin 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

[@Innozant]

Thanks Nirmal,Keep learning.Keep Exploring ❤️👍

[@Marutinandan510]

Really i salute sirr🙌 apka smjhaya hua bahut aache se samjh ata hai

[@Innozant]

Thanks Amit Ji🙏❤️

[@Marutinandan510]

@@Innozanti also thanks you sir for You Teach Everyone💪💪💪

[@arvindbarle6534]

Clearly understood. Thank you. But we need more example like if, and formula etc..

[@Farhansaikh00]

Sir, I am saying that out of 6 subjects, the percentage of 3 subjects should be calculated

[@Farhansaikh00]

Sir I understand your every video very well and like it very much. I watch every video of you

[@mohdnasim2575]

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)

[@Innozant]

Thanks Nasim 👍❤️

[@Arunkumar-ok8yy]

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....

[@Innozant]

Thanks Arun ji

[@flipzonewala]

Very clear explained 👌👌

[@A2Z_103]

Best tutor online

[@bestsong340]

Good sir and great knowledge ❤❤

[@aishwaryaambasta7013]

Easy way to learn..nice sir

[@sandipsingh8377]

Great explanation

[@Innozant]

Thanks Sandip Ji🙏❤️

[@sawaimalhi8439]

bahot he acha wa sir kiya baat hai aaap ki meri parthana aaap ko bahot dua milege

[@Innozant]

Thanks Dear❤❤

[@AdityaKumar-hj4iz]

Bahut badhiya hai sir thoda joom karke bataye sir formula saf nahi dikhta hai. Samjhane ka tarika v apka The best hai sir 👍👍👍👌👌

[@Innozant]

Thanks.mmye old videos h dear ..ab zoom ka issue ni hai latest videos me

[@vivekraghav6176]

Bahut achha padate ho sir

[@anshumishra5239]

Bahut achche se smjhaya sir ap ne

[@vikash545848]

Very informative video Sir

[@dominatorgaming2980]

KZbin ne ye channel mujhe phle suggest kyu nhi kiya itna knowledgeable content or vo bhi free mein.

[@Innozant]

Thanks dear...God bless You

[@593ch]

Which function can use it if() already used but power query getting very slow performance wise

[@tayyabyarkhan1048]

Thank You Sir... Very MUCH..!!!

[@Innozant]

Thanks dear

[@palashroy2977]

very good explanation

[@prathameshjoshi3486]

Thanks a lot sir, great explanation😊

[@jyotijha7910]

Informative content..nice sir

[@hassnainabid3193]

Love from Pkistan.

[@chandrashekharprajapati9451]

That's great video

[@ayeshaayub3387]

need more examples also about AND function

[@dipenchakma602]

though it was three years ago video but it's an excellent video for those who want to learn nested functions.

[@Innozant]

Thanks dear .Keep Learning ❤️

[@E_K18]

Thank you sir 👍🏻👍🏻

[@vimalgupta2917]

you are doning great sir

[@milindpatankarspeaks7159]

Sir how to use this for match of partial text matters

[@paulpal6599]

Love you sir yours teaching skills awesome

[@Innozant]

Thanks ❤️👍

[@shonusephalee2293]

Thank you sir😊

[@awadhesh5574]

Samjane ka tarikha bhout sahi h ...

[@swadealhadecooking5587]

Easy way to learn and explain simple process... Thank u Sir 🙏 Happy New Year 😊

[@Innozant]

Thanks dear

[@yurialexkov2797]

Superb This video cleared my doubts

[@Innozant]

Thanks

[@moharirshyamsunder4879]

SIR MACRO KA VIDEO SHARE KARO ... GREAT WORK .. PROBABLY BEST IN EXCEL SERIES ...

[@Innozant]

Sure dear..you may abow to see complete tutorial ..but need some time as m uoloading power query and power bi these days

[@sathyanarayana4914]

Sir I want information about nested if pls clarify this topic

[@Innozant]

Video se samjh nhi aaya kya nested if aapko?

[@jitendrakumarsinghUP24]

Thanks sir .....i want to learn this function

[@devendergusain8974]

Aagya sir smjh me thnx " NAaRIYAL CHILL DIYA PURA"😁 THNX SIR for this content....

[@Innozant]

Thanks 😃😃😀

[@kitKat-uw8xl]

Sir paragraph likhne k bad cursor upr kaise le k ja skte hi

[@shraddhamahato7498]

Want to know how to retrieve certain value for random fluctuating column and row

[@Innozant]

Hi Shradha ,Kindly explain your query in detail dear..Will guide you for the same.

[@flipzonewala]

Sir iska data entry me kya use hai Please tell me😊

[@Innozant]

As office assistant bhi kaam krenge tab bhi ye basic functions to aana hi chahiye dear

[@jyotichaudhary7231]

Nice content and good explanation 👌

[@Surya.theboi]

Thank you very much. i stay in UAE and want to learn if function with lots of criteria. These criterias are from different cells .

[@chandrashekharmishra9521]

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

[@DKG-MIS]

EXCELLENT TEACHER SIR THANK U FOR TEACH

[@rovar7104]

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 🙏🏻🌻❤🙏🏻

[@Innozant]

Didnt get you,kindly share your query..?

[@nileshchakrabarty9605]

Sir nested if tutorial tak kain assignment kindly bhej saktain hain

[@Kapilgarg199]

Hallo Sir Nested IF Key Assignments mil Shakta Hai

[@pankajwankhade8067]

ur learning style is very easy. superb sir, aapse vba shikhana hai

[@Innozant]

Thanks Pankaj Ji ♥️

[@martinjoseph1535]

I have used multiple if function but it is not working kindly resolve th problem

[@abidnawaz8527]

Sir, how can I send you the picture? I don't feel like asking this question about my work

[@Unknown.Userrr]

Right same situation Sir, give us your email ID

[@garimarawat5086]

It was helpful. Thanks! :)

[@Innozant]

Thanks Garima..Keep learning in sequence step by step and do practice on regular basis. Practice sheet link is there in video description

[@EqbalAKhan]

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

[@yashpal810]

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..... 🙏🙏🙏🙏🙏🙏

[@deepakgoyal761]

Its applicable vedio😎

[@filmydhamaka6898]

Intresting video 😇

[@Innozant]

Thanks for showing your interest in our channel.Keep learning.

[@kumar1dilip]

Please share an example with IFS function, if an example has an blank cell

[@naeemulhassan1426]

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.🌹

[@engrshahidiqbal1974]

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.

[@seemaseema3304]

Good morning sir i watch always your videos and learn many things but sir please i want to use if formula with more example

[@Innozant]

Sure dearmyou may watch our Google sheets playlist as well

[@sakshikate4659]

Pls send more examples for nested if function

[@oliverscheurich9202]

=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")))))

[@sushantw775]

Hello , learning a lot from your videos. can you kindly share more practices question.

[@Innozant]

Hi Sushant..Kindly find practice file link available in video Description (Assignment master folder direct link)

[@ajeetpanwar3446]

Awesome 👍 guru Ji..

[@rohitk4061]

Very nice explain sir

[@Innozant]

thanks rohit ji

[@naveenyadav7996]

This formula uses more levels of nesting to kya karain??

[@HariOm-ei9xm]

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. ?

[@yashpatil3375]

Excellent 👌👍

[@bhavygupta885]

Pdf jaise ki 40 page ki ho use manual excil sheet kaise bnaye km same main kab net se convert na hoti ho file

[@rahulrakshe1988]

Very nice sir

[@Ashishkumar-yc1dt]

Sir, can I get assignments to parctice with data sets?

[@Innozant]

Yes data set is there , Kindky download assignment master from video description

[@muhammadnauman6511]

Sir kindly mujy btayn k mujy Conditional formatting k sath if btayn k Agar meri sys qty=Diff tw Ok otherwise counting mistake

[@poojamishra-wx9fn]

Thanku sr mujhe v fir s padhane k liye

[@dicaprioleo8261]

Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen

[@upendramaurya8797]

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)

[@sharukhpathan9530]

Hi Sir Need question samples for if and nested if..

[@production.coppergat]

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?

[@sajalbajaj6196]

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 ,,,😊

[@Innozant]

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)

[@AlAjalNetworks]

nice Explain sir

[@rkmndora]

Sir nexted if formula me jo condition diya jata he wo har waqt lower se higher hoga na.. like 1st

[@AkashKumar-ci5qg]

Sir nested if ka aur complicated exercise karvayie.

[@7814699999]

Sir 3 cells me agar OK word hai to result OK aaye agar ek men No ho to Not Ok aaye .ye formula btaye

[@sadashivkage3133]

TQ...SIR...🙏🙏

[@karankapoor200]

nice Explain sir👌🏻👌🏻👍🏻👍🏻

[@Innozant]

Thanks Karan for your valuable feedback and showing your interest in our Advance excel training videos.

[@ShyamKumar-hs7gl]

Thanks you sir

[@Sunny-gk1zz]

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

[@prince2008sds]

Sir, If First Column Value 0 & Next Column Value 1 then Third column 0 how to possible in formula please confirm formula

[@RA-rh5lb]

thank you Sir ji

[@NareshDhurvey-b9o]

Thankyou sir

[@IndianTadka.144]

Sir kya nested if aur vlookup ek saath use kar sakte hain? Jaise aapne last main multiply kiya uski jagah vlookup laga ke desired result la sakte hain kya?

[@Innozant]

Koi aisa situation btayen Jahan pe nested if ki jarurat hai aapko vlookup ke saath? Kyu nhi lag sakta hai

[@IndianTadka.144]

@@Innozant suppose kuch patients ka data hai.. un sabko koi na koi medicine chal rahi hai.. ab humko pehle to ye dekhna hai ki agar kisi patient ko medicine chal rahi hai ya nahi, aur agar chal rahi hai to kon kon si chal rahi hai.. aur ab last main un medicine ki class har medicine ke saamne aa jaaye.. aur agar medicine nahi chal rahi to us class wale column main no medicine aa jaye

[@smrutiranjansahani]

Sir, I didn't understand. how can i know ?

[@md.taifuranam7904]

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.

[@Innozant]

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....)