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 you sir ji excel ko sequence me sikhane ke liye bahut log UA-cam 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
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....
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 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")))
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 student ke fail aur pass wale question me agar total percentage 33 se jyada ho lekin student agar kisi ek subject me fail ho , tab bhi bhi ye if condition pass hi dikhaega , par agar usko fail karna ho to arguiment kaisa hoga?
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....)
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)
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..... 🙏🙏🙏🙏🙏🙏
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.🌹
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 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
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 🙏🏻🌻❤🙏🏻
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
You are truly a good teacher .
Thank you for your lectures 🙏
Thanks Abhishek Ji..God bless 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 ❤️
Sir apka bahut bahut dhanyawad....... You're magician sir....✌✌✌
Thanks Rahul Ji👍❤️
You are the best teacher ever. All doubt cleared.
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 👍❤️
सर आप के समझाने का तरीका बहुत ही बढ़िया है और आपके विडियो से बहुत कुछ सीखने को मिलता है ।
धन्यवाद सर
Thanks dear ❤️❤️
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💪💪💪
Thanks you sir ji excel ko sequence me sikhane ke liye bahut log UA-cam 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 ❤️👍
Thank u for your kind support and encouragement
bahot he acha wa sir kiya baat hai aaap ki meri parthana aaap ko bahot dua milege
Thanks Dear❤❤
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
Very clear explained 👌👌
Best tutor online
Which function can use it if() already used but power query getting very slow performance wise
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 achche se smjhaya sir ap ne
Easy way to learn..nice sir
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
Easy way to learn and explain simple process... Thank u Sir 🙏
Happy New Year 😊
Thanks dear
Good sir and great knowledge ❤❤
Great explanation
Thanks Sandip Ji🙏❤️
UA-cam ne ye channel mujhe phle suggest kyu nhi kiya itna knowledgeable content or vo bhi free mein.
Thanks dear...God bless You
Thanks a lot sir, great explanation😊
Thank you sir 👍🏻👍🏻
Informative content..nice sir
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?
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)
Sir how to use this for match of partial text matters
Thank You Sir... Very MUCH..!!!
Thanks dear
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 ❤️
Bahut achha padate ho sir
Very informative video Sir
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")))
Love you sir yours teaching skills awesome
Thanks ❤️👍
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.
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
Love from Pkistan.
EXCELLENT TEACHER SIR THANK U FOR TEACH
Samjane ka tarikha bhout sahi h ...
Sir I want information about nested if pls clarify this topic
Video se samjh nhi aaya kya nested if aapko?
Superb
This video cleared my doubts
Thanks
Aagya sir smjh me thnx " NAaRIYAL CHILL DIYA PURA"😁 THNX SIR for this content....
Thanks 😃😃😀
Nice content and good explanation 👌
ur learning style is very easy. superb sir, aapse vba shikhana hai
Thanks Pankaj Ji ♥️
you are doning great 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. ?
Sir nexted if formula me jo condition diya jata he wo har waqt lower se higher hoga na.. like 1st
very good explanation
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 student ke fail aur pass wale question me agar total percentage 33 se jyada ho lekin student agar kisi ek subject me fail ho , tab bhi bhi ye if condition pass hi dikhaega , par agar usko fail karna ho to arguiment kaisa hoga?
This formula uses more levels of nesting to kya karain??
Thank you very much. i stay in UAE and want to learn if function with lots of criteria. These criterias are from different cells .
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
That's great video
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 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
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)
need more examples also about AND function
Sir, can I get assignments to parctice with data sets?
Yes data set is there , Kindky download assignment master from video description
Sir paragraph likhne k bad cursor upr kaise le k ja skte hi
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)
I have used multiple if function but it is not working kindly resolve th problem
Hi Sir
Need question samples for if and nested if..
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..... 🙏🙏🙏🙏🙏🙏
Thank you sir😊
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 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 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
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")))))
Thanks sir .....i want to learn this function
Hallo Sir Nested IF Key Assignments mil Shakta Hai
Please share an example with IFS function, if an example has an blank cell
Intresting video 😇
Thanks for showing your interest in our channel.Keep learning.
Sir nested if tutorial tak kain assignment kindly bhej saktain hain
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
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.🌹
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?
Koi aisa situation btayen Jahan pe nested if ki jarurat hai aapko vlookup ke saath?
Kyu nhi lag sakta hai
@@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
sir preparing for MIs , I think there is videos series missing of chart , have you posted or not yet ??
Chart series already started
Sir, If First Column Value 0 & Next Column Value 1 then Third column 0 how to possible in formula please confirm formula
Sir 3 cells me agar OK word hai to result OK aaye agar ek men No ho to Not Ok aaye .ye formula btaye
Its applicable vedio😎
Pdf jaise ki 40 page ki ho use manual excil sheet kaise bnaye km same main kab net se convert na hoti ho file
Very nice explain sir
thanks rohit ji
can I get some sheets for if and ifs function?
Hi Shruti,Please find assignment file in video Description (Download Link are there)
Sir kindly mujy btayn k mujy Conditional formatting k sath if btayn k Agar meri sys qty=Diff tw Ok otherwise counting mistake
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
Awesome 👍 guru Ji..
TQ...SIR...🙏🙏
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..?
Sir,
I didn't understand. how can i know ?
nice Explain sir👌🏻👌🏻👍🏻👍🏻
Thanks Karan for your valuable feedback and showing your interest in our Advance excel training videos.
Sir muze long nested if formulas me bracket kaha lagana isme problem aata hai. Please make one video regarding the brackets (parenthesis).
Ok Shrikant ji..Wil guuide you for the same
.
If function practice sheet not available.
If function practice sheet (If related all function)not available in assignment master, pls share as soon as possible.
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 can I use ISBLANK and AND Formula together?
Yes you can
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