Sir thnx u ache se smjh aarha h apki video 4-5 bar dekh rha hun.... Ab aap hi hope ho sir vrna to maine soch liya tha kuch nhi hone vala mera.... Jbse apka channel subscribe kiya h sir or channel boring lgte hain sir thnx for these all free content jo meri coaching tak me nhi seekha vo yhaan seekh rha hun apki video se thnx u so much
Sir ji agar aapke video kisko nahi pasand aaya tho phir yourtube ke saare videos fail jo jayenge.. you are the best .. aisa lagtha hai ek maa apne bache ko apne hisab se padathi hai 😊aur bache ko acche se samj aathi hai.. I am one of those students.. thank you so much
Sir finally if nested or and Ka concept samaj aagaya hai thoda SA time laga samajne mein but all doubts and concept clear kyunki sir mein aapki video ko pause Kar Baar Baar dekhta tha Jab thak samaj nahin Aaye 🙏sir👍
Sir jee. thank you for sharing the knowledge about excel. Aaapk samjahne ka tareeka bhi bahut pasanad aaya mujhe. U explain step-by-step very well and in a manner that it stays in the memory. Bas ek hee guzaarish hai ki koi practice assignemnt bhi uplabdh karwa dijiye.
dear and or concept ke video ek baar phirse dekhen..ho jayega concept clear..jab saare condition true honge to and use karen..jab option ho ki ya to ye nahi to ye to OR use kren
sir apka har video very good sir excel me series by series video bnaye jaise formulas tab ----> text me puri option ka ho and logical me puri option ka ho
Thanks Mehak .Step by step in sequence seekhte jaiye aur practice jaroor karna.God Bless You ❤️❤️ @innozantofficial telegram id par koi bhi query aaye to puch sakte hain aap👍
Sir mene customer billing wale qts me jaha OR function lagana tha, mene waha nested loop laga kar dekha. =IF(C2>20000,C2*30%,IF(D2>=10,D2*30%)). Sir according to qts is fuction se be ans milrai. Sir aisa b kar sakte hai kya?
hello sir can we do this calculations of discount through multiple if too? as when we need to put false we can add one more if to test two conditions i know you want to make us learn And/ OR but just doubt came ?
Ans me mene nikala tha ki agar qty blank he to usi cell me invalid qty lika kar a jaye agar price blank he to usi cell me invalid price likh kar a jaye
dono same kaise ho sakta hai jab name alag hai..Nitesh ji.. or -if any of the argument are true the result is true and-if all of the arguments are true the result is true
Sir Muje excel ki workbook kisi ko copy kar ke deni ho par vo workbook ka sabhi formula limited days me delete karna he To please muje bataye ye kese hoga? Kya ye possible he? Please reply karna
In or function if any of the argument true the result is true ,if all argument false then only result is false. Evalue depend on or function argument criteria.
sir, I have two columns. In the first column product name and the second column contains its value. I want to create another list that contains only a product list with values greater than zero in the second column. And if the value is zero in the second column then it displays the next name with a value greater than zero automatically. Please guide.
Sir how can we use if + and together if there are 4 arguments. For eg if we're asked to calculate the commission based on net profit. Conditions for which are as follow : Net profit : $7,164 and conditions : >=10,000 - 5% ; >=5000 and
Bilkul nahi Sandhya.. Phirse dekhiye video ,OR tab use karenge if ke saath yadi this or that wala case hoga that means ye nahi to wo sahi (jaise ydi aapne 5000 se jyada ka purchase Kiya to bhi 10 percent discount milega ya aapne 5 koi aur product buy kar liya tab bhi 10 percent milega) But AND ke case me jitne bhi condition paas karneh sabhi true hoga tabhi result true layega jabki or ke case me koi bhi ek condition sahi to bhi result sahi aayega. Aap sequence me video dekhiye aayega samjh easily .❤️👍
ye vedio ka practice file nahi hai foloder maine ... agar hoga to kis name ka hai .... sare folder check kiye but abhi nahi nahi file dikhi folder maine
@@Innozant Sir thanks for this reply Good morning sir Sir can u give me your email ID I send you this question I don't know how to explain Thank you Sir
Sir single cell me multiple condition per kya And , or function per vedio upload ker help kre. such as (A1=9,A1=10,A1=11), value 9 hai to 290, 10 hai to 299, 11 hai to 310 =if(A1=9,290,if(A1=10,299,if(A1=11,310,"") is function ko AND , OR function se kaise kre
Are sir sidhi si baat hai.. Jo kaam nested if se kar rahe the bar bar chalana pad raha tha.. Buss ab nahi chalana padega.. Ku k if k sath or and function laga lenge😂
sir mene if or wale condition ko nested if se nikalne ki koshish ki =IF(C2>=20000,C2*30%,IF(D2>=10,C2*30%,"No discount")) to isme bhi result same hi aya kya ye appraoch bhi correct hai ???😁😁🤷♂️🤷♂️
=IF(OR(C2>=20000,D2>=10),C2*30%,"No discount") / =IF(C2>=20000,C2*30%,IF(D2>=10,C2*30%,"No discount")) Sir dono se output same hi nikal raha hai aap hai bss dono mai se if(or()) wala method thoda sort or easy mujhe itna hi fark laga dono method mai baaki result same hai dono Sir kya apke hisab se dono hi method correct hai ya mai kuch mistake krr rha hun sir please meri confusion clear kre.🙏🙏🙏🙏
Sir, I Ddont Know Advance Excel, But now i know Advance Excel. Thanks for you for your Video. U r a best Teacher. Your teaching Language is very easy.
Thanks dear..keep learning
Sir thnx u ache se smjh aarha h apki video 4-5 bar dekh rha hun.... Ab aap hi hope ho sir vrna to maine soch liya tha kuch nhi hone vala mera.... Jbse apka channel subscribe kiya h sir or channel boring lgte hain sir thnx for these all free content jo meri coaching tak me nhi seekha vo yhaan seekh rha hun apki video se thnx u so much
Thanks Devender for showing your trust and love ,Will always guide and support you..
Value for Money style of teaching.... Ek ek topic crystal clear... Thanks
Thanks Khan Sahab..Really means a lot to me..Happy learning
Sir, me apka sikhane dedication dekh kar me apko salute karna chahta hu.
Love you Pradeep Ji .. Happy learning. Thanks for your love and support 🙏❤️
College me tha tab sikha tha Digital Electronics subject me AND & OR. Aaj acche se samjh aaya.
Thanks dear❤️
Sir ji agar aapke video kisko nahi pasand aaya tho phir yourtube ke saare videos fail jo jayenge.. you are the best .. aisa lagtha hai ek maa apne bache ko apne hisab se padathi hai 😊aur bache ko acche se samj aathi hai.. I am one of those students.. thank you so much
Really means a lot to me
Thank you Sir !! Appka Explaination ek dum simple tarike se hain... Shukriyaa aapka.
Thanks Kiran Ji
Sir finally if nested or and Ka concept samaj aagaya hai thoda SA time laga samajne mein but all doubts and concept clear kyunki sir mein aapki video ko pause Kar Baar Baar dekhta tha Jab thak samaj nahin Aaye 🙏sir👍
ماشاءاللہ سر آپ نے بہت اچھا سمجھا یا ہے
مبروك لك
Best channel for Excel on UA-cam......superb content ❤
Thanks ..Keep Learning
Thanks Sir, you are Brilliant and Superstar of India, you are serving the People,
Best channel to learn excel. This channel helped me pass my excel test for the job. ❤
Thanks
Aap bahut achha concept clear karto ho..
Thanks Rahul
Thank you so much sir. AND, OR ki confusion duur krva dii apne meri.
Thanks Anil Ji ❤️❤️
Bhai..mein to apka fan hogaya.. wo v jabra..🤗
Hahahaha.mThanks Sayed..God bless you❤️
By this way of teaching, even a baby in the cradle can be taught
Thanks dear❤️❤️♥️👍
جزاکم اللّٰہ خیرا کثیرا کثیرا سر
Your vidos are very informative . I encourge your effort. You are doing your job very well. Your Method is very Prcital. I learn alot from you vidos.
Thanks.Really means a lot to me
Bahut achha se explain kiya sir aapne
Thanks
Sir Ur my bestest teacher
Thanks
Nariyal chill diya sir is video me bhi......💕❤️❤️❤️❤️
hahahaha..Thanks Devender ji
Very Very Helpful Sir Thankyou So Much
Thanks Suraj
Very nice way to teach.
Thanks Shwet👍❤️
Beautiful style of teaching
Thanks Aatif sahab
Sir jee. thank you for sharing the knowledge about excel. Aaapk samjahne ka tareeka bhi bahut pasanad aaya mujhe. U explain step-by-step very well and in a manner that it stays in the memory. Bas ek hee guzaarish hai ki koi practice assignemnt bhi uplabdh karwa dijiye.
Thanks dear..complete excercise available hain..video description me Jake link se download krke practice karen
bahoat he acha samajaya sir ...ek main sawal hai k kab hum and use kringe kab hum and use kringe ????
dear and or concept ke video ek baar phirse dekhen..ho jayega concept clear..jab saare condition true honge to and use karen..jab option ho ki ya to ye nahi to ye to OR use kren
sir apka har video very good
sir excel me series by series video bnaye
jaise formulas tab ----> text me puri option ka ho and logical me puri option ka ho
Thanks Aftabmmaise series wise video ka context match nhi krega jabki complete videos bana diye hain dear..aap topic wise learn karen na ki tab wise
Sir, in filter option when I run filter in sheet one into extra row added in filter with different name, what was error pl guide me
Explain nicely..useful for beginner learner.
Thanku so much sir aapki vajah se mjhee ye topic bhot ache se samajh agya☺🤞
Thanks Mehak .Step by step in sequence seekhte jaiye aur practice jaroor karna.God Bless You ❤️❤️
@innozantofficial telegram id par koi bhi query aaye to puch sakte hain aap👍
Sir, do you have videos on data validation
Yes watch play list in sequence
very use full function🙏🙏👍🏻👍🏻
sir, we can use double if as you learn in last vidoe
I salute your way of teaching, Superb
Thanks Rahul..God bless you..Happy lead 🙏❤️
Sir mene customer billing wale qts me jaha OR function lagana tha, mene waha nested loop laga kar dekha.
=IF(C2>20000,C2*30%,IF(D2>=10,D2*30%)).
Sir according to qts is fuction se be ans milrai. Sir aisa b kar sakte hai kya?
Keep it up sir.. Very useful function.. Thanx...
Very well explained
Excellent way of teaching...simply great
Thanks dear
Good teaching abilities.
sir if function wali files mill gyi practical assignment mai se thank you
👍❤️
hello sir can we do this calculations of discount through multiple if too? as when we need to put false we can add one more if to test two conditions i know you want to make us learn And/ OR but just doubt came ?
Sir nested if ke aur example bhi bta do
Sir can we use ifs function in this rather than if (or) function
Crystal clear sir thanks 👍
Sir apne jo next video me qty aur price wala ques kra tha sir aj mene use and condition lga ke ans nikala tha
Ans me mene nikala tha ki agar qty blank he to usi cell me invalid qty lika kar a jaye agar price blank he to usi cell me invalid price likh kar a jaye
best sir for excel
best teacher
Sir (or) (and) ye dono Kam to same krte hai koi bhi or kbhi bhi lga skte hai na ye faction
dono same kaise ho sakta hai jab name alag hai..Nitesh ji..
or -if any of the argument are true the result is true
and-if all of the arguments are true the result is true
Requesting to do multiple criteria matches with if and AND
👍
Thank you🙏🙏🙏🙏 sir very very thank you
How to set if formula if I divide and it comes whole number then 1 multiple else next colum value
Superb sir ji
Dono ka result kya same aayega
Agr if +or, & if + and dono me se ik ka use krenge
Kyu same aayega jab function 2 hain to dear, Maine or ka and ka concept jo btaya hai use ek baar dekhiye video ..bikul samjh aayega apko concept
Sir please make a video for Searchable Dropdown list(data in a table and using vba code).
Haan ye bana dete hain jald
Plz try to explain excel course I zoom in position, so that we could easily understand. Thanks
Dear Deepak..Thanks for your suggestions.noted
awesome video
Vartual class kaise join karenge sir please comment me bataye.
Aap Innozant website visit karke upcoming batches ka detail le sakte hain ya contact no. Par call karke .
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
Brilliant teaching 👍 always
Thanks dear...Happy learning dear
Dear sir good morning
No display clear picture of sheet or formulla in excel, so request to yo please share with clear video
Ye pehle ke videos hain ,aap laptop par dekhne ..sahi aayega display
Sir jb hum(and) ka use krte to cell ko frize krna jarori hai na ye hi and ki pehchan hai na...?
Nahi..Freeze ka and or se koi lena nahi hai.
Sir jb ham Kisi row ko shift + ctrl + down se select krte hai to ek dam last Mai a jate hai to 1cell pr kese aye ...?
Ctrl + backspace
Jb Kisi cell ko frize krna ho ...f4 pres krte hai but laptop par frize nhi hota hai ....?
Laptop par function key ke saath f4 press karenge
Great sir ji
Good explain
Sir, Ye Ham IFS se v kar sakte hai.
Yes
Thanks Sir.
Thank you sir
Sir
Muje excel ki workbook kisi ko copy kar ke deni ho par vo workbook ka sabhi formula limited days me delete karna he
To please muje bataye ye kese hoga?
Kya ye possible he?
Please reply karna
sir jb main ise alag alag aply krta hoon to sahi to condition thik hai par jb dono ko merge kraha hoon to error aata hai
Sir please help me to resolve a query
Calculate the total working day except Saturday and Sunday from 1-May-2022 to 31-May-2022
You can use Networking Days function
SIR,IN OR FUNCTION IF FIRST CONDITION EVALUATES TRUE THEN OR FUNCTION WILL ALSO EVALUTE SECOND CONDITION?
In or function if any of the argument true the result is true ,if all argument false then only result is false.
Evalue depend on or function argument criteria.
Just awesome sir.
Thanks dear
formula hide and unhide kise krte hain sir ??
ctrl+1 protection-hidden pe check krke phir sheet ko protect kar dein
security topic ka video dekh lijiye karaya hai maine
TQ...SIR...🙏🙏
Sir.ji amazing 😆
Thanks Sanoj ji
Hi Sir
I need little help on one topic!!How can I send you my sheet
@innozantofficiap.telegram id
@@Innozant Sent on the telegram.
sir, I have two columns. In the first column product name and the second column contains its value. I want to create another list that contains only a product list with values greater than zero in the second column. And if the value is zero in the second column then it displays the next name with a value greater than zero automatically. Please guide.
sir how to join your virtual classes for SQL, I have already raised request for call back on innozant site but no call received yet.
Weekend Batch is running for sql .You may contact us for further detail on 7065069985
How to apply if and Vlookup functions in Excel ?
Kindly Watch lookup series
Sir freeze kese krte hai, uski short key ky h?
Please tell.
F4 ..aap basic excel ke pehle video se seekhna start kriye .
Hello Sir......!
Thank you very much for such valuable inputs. Can you please send us some assignments so that we can practise the same.
Kindly watch Proquest series for assignment ..and download that sheet for practice
@@Innozant Thanks
Sir aap online bhi padate ho
Yes ..kindly connect with team innozant
Best class
Thanks dear
Thanks u sir
Sir how can we use if + and together if there are 4 arguments. For eg if we're asked to calculate the commission based on net profit. Conditions for which are as follow : Net profit : $7,164 and conditions : >=10,000 - 5% ; >=5000 and
Kindly share excel sheet @innozantofficial telegram id with query
If ke sath or ya and lgana same chiz h ?
Bilkul nahi Sandhya..
Phirse dekhiye video ,OR tab use karenge if ke saath yadi this or that wala case hoga that means ye nahi to wo sahi (jaise ydi aapne 5000 se jyada ka purchase Kiya to bhi 10 percent discount milega ya aapne 5 koi aur product buy kar liya tab bhi 10 percent milega)
But AND ke case me jitne bhi condition paas karneh sabhi true hoga tabhi result true layega jabki or ke case me koi bhi ek condition sahi to bhi result sahi aayega.
Aap sequence me video dekhiye aayega samjh easily .❤️👍
Thanx sir
Sir apka paid course kaise milega online...
Innozant website visit kariye ..wahan video course available hain ya aap live class join karna chahte hain to Innozant team se connect kariye
Pdf to word word se excel kese krte h sir
Video hai already channel par iska dear
ye vedio ka practice file nahi hai foloder maine ... agar hoga to kis name ka hai .... sare folder check kiye but abhi nahi nahi file dikhi folder maine
Folder hain playlist wise
Sir I need for your help please reply me
Hi Savita kindly ask your query @innozantofficial telegram id
@@Innozant Sir thanks for this reply
Good morning sir
Sir can u give me your email ID I send you this question
I don't know how to explain
Thank you Sir
@@savitabirje4953 @innozantofficial telegram id for excel query support
Thnq sir ji
Sir, me apka sikhane dedication dekh kar me apko salute karna chahta hu.
Boss always boss salute for innozant team and sir,
Thank you🙏 oo sir gg
Nice bro
Thanks
sirrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
please give a detail playlist about DAX
Sir
If A=1 then value 0.6, if A=10 then value 0.9 , if A >1 or
Sir single cell me multiple condition per kya And , or function per vedio upload ker help kre.
such as (A1=9,A1=10,A1=11), value 9 hai to 290, 10 hai to 299, 11 hai to 310
=if(A1=9,290,if(A1=10,299,if(A1=11,310,"")
is function ko AND , OR function se kaise kre
Nice
Very very much
Are sir sidhi si baat hai.. Jo kaam nested if se kar rahe the bar bar chalana pad raha tha.. Buss ab nahi chalana padega.. Ku k if k sath or and function laga lenge😂
sir mene if or wale condition ko nested if se nikalne ki koshish ki =IF(C2>=20000,C2*30%,IF(D2>=10,C2*30%,"No discount")) to isme bhi result same hi aya kya ye appraoch bhi correct hai ???😁😁🤷♂️🤷♂️
Hahahaha...aap khud evaluate krke dekhiye aur phir btaiye kya yw sachme wahi output la raha hai jo hum expect?
=IF(OR(C2>=20000,D2>=10),C2*30%,"No discount") / =IF(C2>=20000,C2*30%,IF(D2>=10,C2*30%,"No discount")) Sir dono se output same hi nikal raha hai aap hai bss dono mai se if(or()) wala method thoda sort or easy mujhe itna hi fark laga dono method mai baaki result same hai dono Sir kya apke hisab se dono hi method correct hai ya mai kuch mistake krr rha hun sir please meri confusion clear kre.🙏🙏🙏🙏