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 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
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 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.
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
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
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
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 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?
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 kindly solve this equation... Count the total number of days you worked from home in the year due to the COVID-19 pandemic and multiply that by $2 per day. This amount will be your claim for the year (up to a maximum of $400 per individual in 2020 and $500 per individual in 2021 and in 2022). # of days you worked from home within the period (maximum 200 days for 2020 and 250 days for 2021 and for 2022) times by$2 (temporary flat rate amount) equalsAmount of your claim (to a maximum of $400 in 2020 and $500 in 2021 and in 2022)
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.
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.
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 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
sir plz help,,, =IF(AND($J2="Band 6",$AU2>30),"Out TAT","In TAT") condition 2,,,,,,=IF(AND($J2="Band 5 & Above",$AU2>45),"Out TAT","In TAT") sir please guide where i am wrong and how can i excute in one shot
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
Value for Money style of teaching.... Ek ek topic crystal clear... Thanks
Thanks Khan Sahab..Really means a lot to me..Happy learning
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
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
Thank you Sir !! Appka Explaination ek dum simple tarike se hain... Shukriyaa aapka.
Thanks Kiran Ji
Best channel for Excel on TH-cam......superb content ❤
Thanks ..Keep Learning
College me tha tab sikha tha Digital Electronics subject me AND & OR. Aaj acche se samjh aaya.
Thanks dear❤️
جزاکم اللّٰہ خیرا کثیرا کثیرا سر
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 🙏❤️
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 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..
Thank you so much sir. AND, OR ki confusion duur krva dii apne meri.
Thanks Anil Ji ❤️❤️
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
Sir Ur my bestest teacher
Thanks
Aap bahut achha concept clear karto ho..
Thanks Rahul
Explain nicely..useful for beginner learner.
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
Very Very Helpful Sir Thankyou So Much
Thanks Suraj
Bhai..mein to apka fan hogaya.. wo v jabra..🤗
Hahahaha.mThanks Sayed..God bless you❤️
Bahut achha se explain kiya sir aapne
Thanks
Nariyal chill diya sir is video me bhi......💕❤️❤️❤️❤️
hahahaha..Thanks Devender ji
Beautiful style of teaching
Thanks Aatif sahab
Crystal clear sir thanks 👍
very use full function🙏🙏👍🏻👍🏻
Very well explained
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👍
Keep it up sir.. Very useful function.. Thanx...
Excellent way of teaching...simply great
Thanks dear
best sir for excel
Very nice way to teach.
Thanks Shwet👍❤️
Good teaching abilities.
best teacher
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
I salute your way of teaching, Superb
Thanks Rahul..God bless you..Happy lead 🙏❤️
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
Thank you🙏🙏🙏🙏 sir very very thank you
sir, we can use double if as you learn in last vidoe
sir if function wali files mill gyi practical assignment mai se thank you
👍❤️
awesome video
Thanks Sir.
Great sir ji
Thank you sir
Just awesome sir.
Thanks dear
Good explain
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
TQ...SIR...🙏🙏
Brilliant teaching 👍 always
Thanks dear...Happy learning dear
Sir nested if ke aur example bhi bta do
Thanks u sir
Requesting to do multiple criteria matches with if and AND
👍
Thanx sir
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
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 please make a video for Searchable Dropdown list(data in a table and using vba code).
Haan ye bana dete hain jald
Best class
Thanks dear
Sir can we use ifs function in this rather than if (or) function
Thnq sir ji
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
Sir.ji amazing 😆
Thanks Sanoj ji
Sir, do you have videos on data validation
Yes watch play list in sequence
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?
Plz try to explain excel course I zoom in position, so that we could easily understand. Thanks
Dear Deepak..Thanks for your suggestions.noted
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
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 kindly solve this equation... Count the total number of days you worked from home in the year due to the COVID-19 pandemic and multiply that by $2 per day. This amount will be your claim for the year (up to a maximum of $400 per individual in 2020 and $500 per individual in 2021 and in 2022).
# of days you worked from home within the period (maximum 200 days for 2020 and 250 days for 2021 and for 2022)
times by$2 (temporary flat rate amount)
equalsAmount of your claim (to a maximum of $400 in 2020 and $500 in 2021 and in 2022)
Thank you🙏 oo sir gg
How to set if formula if I divide and it comes whole number then 1 multiple else next colum value
sirrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
please give a detail playlist about DAX
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.
Nice
Nice bro
Thanks
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
👍
Jabardast
Thanks
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.
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 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 (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
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
Sir, me apka sikhane dedication dekh kar me apko salute karna chahta hu.
Boss always boss salute for innozant team and sir,
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
If A=1 then value 0.6, if A=10 then value 0.9 , if A >1 or
Sir aap online bhi padate ho
Yes ..kindly connect with team innozant
How to apply if and Vlookup functions in Excel ?
Kindly Watch lookup series
❤️❤️❤️❤️❤️❤️
Thanks Sajid❤️🙏
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
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
👍👍
sir plz help,,, =IF(AND($J2="Band 6",$AU2>30),"Out TAT","In TAT") condition 2,,,,,,=IF(AND($J2="Band 5 & Above",$AU2>45),"Out TAT","In TAT") sir please guide where i am wrong and how can i excute in one shot
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
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 .
From last one month I have completed only 25 videos.
My question is, How much videos should I watch daily ? Please advise.
Learn slowly with daily practice is required.Take your time.. Happy learning
👍
Thanks Rahul
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
May I ask Sir, aapke Qualification kya hai, what is your profession?
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 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