Excel Logical Function-OR function , AND function

Excel Logical function - OR function , AND function | Excel in Hindi
1. Logical functions -OR Function
2. Logical functions -AND Function
3. IF Function , And Function , OR Function Example
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...
#exceltricks #exceltutorial #innozant #excelshortcutKey

[@PradeepKumar-hd1ty]

Sir, me apka sikhane dedication dekh kar me apko salute karna chahta hu.

[@nitin6050]

Boss always boss salute for innozant team and sir,

[@MoinKhan-wb2fx]

Value for Money style of teaching.... Ek ek topic crystal clear... Thanks

[@Innozant]

Thanks Khan Sahab..Really means a lot to me..Happy learning

[@AllahDitta-gp5lt]

جزاکم اللّٰہ خیرا کثیرا کثیرا سر

[@RaviRanjanSingh-xd5qh]

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.

[@Innozant]

Thanks dear..keep learning

[@farhanilyas12]

Thanks Sir, you are Brilliant and Superstar of India, you are serving the People,

[@navabalam7996]

ماشاءاللہ سر آپ نے بہت اچھا سمجھا یا ہے
مبروك لك

[@nadiakhan9189]

Best channel to learn excel. This channel helped me pass my excel test for the job. ❤

[@Innozant]

Thanks

[@BharatBhaktiSong]

Thank you Sir !! Appka Explaination ek dum simple tarike se hain... Shukriyaa aapka.

[@Innozant]

Thanks Kiran Ji

[@mukeshgoswami2431]

Best channel for Excel on TH-cam......superb content ❤

[@Innozant]

Thanks ..Keep Learning

[@RA-rh5lb]

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

[@Innozant]

Really means a lot to me

[@devendergusain8974]

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

[@Innozant]

Thanks Devender for showing your trust and love ,Will always guide and support you..

[@adarshak4767]

College me tha tab sikha tha Digital Electronics subject me AND & OR. Aaj acche se samjh aaya.

[@Innozant]

Thanks dear❤️

[@findfactYt]

Sir Ur my bestest teacher

[@Innozant]

Thanks

[@iamsainipawan]

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👍

[@DelhiKPahadi]

Very Very Helpful Sir Thankyou So Much

[@Innozant]

Thanks Suraj

[@anilrajput6497]

Thank you so much sir. AND, OR ki confusion duur krva dii apne meri.

[@Innozant]

Thanks Anil Ji ❤️❤️

[@muhammadnaeem4237]

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.

[@Innozant]

Thanks.Really means a lot to me

[@engg.sudarshanverma6599]

By this way of teaching, even a baby in the cradle can be taught

[@Innozant]

Thanks dear❤️❤️♥️👍

[@rahulrakshe1988]

Aap bahut achha concept clear karto ho..

[@Innozant]

Thanks Rahul

[@sayed_moin]

Bhai..mein to apka fan hogaya.. wo v jabra..🤗

[@Innozant]

Hahahaha.mThanks Sayed..God bless you❤️

[@jyotijha7910]

Explain nicely..useful for beginner learner.

[@devendergusain8974]

Nariyal chill diya sir is video me bhi......💕❤️❤️❤️❤️

[@Innozant]

hahahaha..Thanks Devender ji

[@nehagupta2917]

best sir for excel

[@banjareroshani3326]

Bahut achha se explain kiya sir aapne

[@Innozant]

Thanks

[@vikasbhargava1703]

Excellent way of teaching...simply great

[@Innozant]

Thanks dear

[@aatifrashid5413]

Beautiful style of teaching

[@Innozant]

Thanks Aatif sahab

[@aftaballam3990]

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

[@Innozant]

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

[@karankapoor200]

very use full function🙏🙏👍🏻👍🏻

[@zainabahsan2860]

best teacher

[@22_nareshkachori68]

Crystal clear sir thanks 👍

[@SunilKumar-xb7dj]

Very well explained

[@aqeelahmadengr3]

Good teaching abilities.

[@AbdulHamid-ci9kz]

Thanks Sir.

[@rahulthakur2392]

I salute your way of teaching, Superb

[@Innozant]

Thanks Rahul..God bless you..Happy lead 🙏❤️

[@mehakkhanna303]

Thanku so much sir aapki vajah se mjhee ye topic bhot ache se samajh agya☺🤞

[@Innozant]

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👍

[@bhagwatidave1154]

Thank you sir

[@mdsajjadhussain2653]

Keep it up sir.. Very useful function.. Thanx...

[@shwetkumar1719]

Very nice way to teach.

[@Innozant]

Thanks Shwet👍❤️

[@rishisonirishissoni]

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.

[@Innozant]

Thanks dear..complete excercise available hain..video description me Jake link se download krke practice karen

[@rajpatel4596]

Good explain

[@kartickrajwar296]

Thank you🙏🙏🙏🙏 sir very very thank you

[@dubeypushpendra4558]

awesome video

[@sadashivkage3133]

TQ...SIR...🙏🙏

[@sawaimalhi8439]

bahoat he acha samajaya sir ...ek main sawal hai k kab hum and use kringe kab hum and use kringe ????

[@Innozant]

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

[@vishalmandiya8225]

Great sir ji

[@dheerajdhawan4374]

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 ?

[@AllahDitta-gp5lt]

Thanks u sir

[@RahulKumar93555]

Thanx sir

[@T1KT0KOY]

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

[@srinivasbattula1863]

Sir, do you have videos on data validation

[@Innozant]

Yes watch play list in sequence

[@shaikvalli1414]

Requesting to do multiple criteria matches with if and AND

[@Innozant]

👍

[@kartickrajwar296]

Very very much

[@akashkumar-oi1fw]

sir if function wali files mill gyi practical assignment mai se thank you

[@Innozant]

👍❤️

[@vikaskumar-mk9wx]

Best class

[@Innozant]

Thanks dear

[@animals-video261]

Brilliant teaching 👍 always

[@Innozant]

Thanks dear...Happy learning dear

[@VaibhavGupta-p6o]

Sir can we use ifs function in this rather than if (or) function

[@chowdhurysunzidmahbub79]

Just awesome sir.

[@Innozant]

Thanks dear

[@amiitmish3]

How to set if formula if I divide and it comes whole number then 1 multiple else next colum value

[@myapp9067]

Sir please make a video for Searchable Dropdown list(data in a table and using vba code).

[@Innozant]

Haan ye bana dete hain jald

[@kartickrajwar296]

Thank you🙏 oo sir gg

[@sanjayrathore8599]

Sir apne jo next video me qty aur price wala ques kra tha sir aj mene use and condition lga ke ans nikala tha

[@sanjayrathore8599]

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

[@tjr1421]

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?

[@gauravbhatia7987]

Thnq sir ji

[@dicaprioleo8261]

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

[@meditationmusic6482]

Sir.ji amazing 😆

[@Innozant]

Thanks Sanoj ji

[@vitaherbal3978]

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.

[@Nitesh-sq7ci]

Sir (or) (and) ye dono Kam to same krte hai koi bhi or kbhi bhi lga skte hai na ye faction

[@Innozant]

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

[@aklasuddin1777]

Nice

[@deepakbarua8087]

Plz try to explain excel course I zoom in position, so that we could easily understand. Thanks

[@Innozant]

Dear Deepak..Thanks for your suggestions.noted

[@hassanshahzad4964]

👍

[@sitoshkumar6518]

Dear sir good morning
No display clear picture of sheet or formulla in excel, so request to yo please share with clear video

[@Innozant]

Ye pehle ke videos hain ,aap laptop par dekhne ..sahi aayega display

[@AshuMishra-mx7bc]

Sir aap online bhi padate ho

[@Innozant]

Yes ..kindly connect with team innozant

[@SinghSurinder16]

Superb sir ji
Dono ka result kya same aayega
Agr if +or, & if + and dono me se ik ka use krenge

[@Innozant]

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

[@sachinsanil7147]

How to apply if and Vlookup functions in Excel ?

[@Innozant]

Kindly Watch lookup series

[@Abdulwaheed-pp1nj]

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

[@neeshusingh5908]

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

[@latestpunjabisongs2839]

You can use Networking Days function

[@RaviRanjanSingh-xd5qh]

Sir, Ye Ham IFS se v kar sakte hai.

[@Innozant]

Yes

[@zubairansari4404]

Hello Sir......!
Thank you very much for such valuable inputs. Can you please send us some assignments so that we can practise the same.

[@Innozant]

Kindly watch Proquest series for assignment ..and download that sheet for practice

[@zubairansari4404]

@@Innozant Thanks

[@ajaysaroha2539]

SIR,IN OR FUNCTION IF FIRST CONDITION EVALUATES TRUE THEN OR FUNCTION WILL ALSO EVALUTE SECOND CONDITION?

[@Innozant]

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.

[@barbhayar]

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

[@sawaimalhi8439]

formula hide and unhide kise krte hain sir ??

[@Innozant]

ctrl+1 protection-hidden pe check krke phir sheet ko protect kar dein
security topic ka video dekh lijiye karaya hai maine

[@rahulrakshe1988]

Nice bro

[@Innozant]

Thanks

[@raj55581]

Sir
If A=1 then value 0.6, if A=10 then value 0.9 , if A >1 or

[@nikitarai3701]

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

[@Innozant]

Kindly share excel sheet @innozantofficial telegram id with query

[@Marathiboost]

Jabardast

[@Innozant]

Thanks

[@AdityaKumar-hj4iz]

Vartual class kaise join karenge sir please comment me bataye.

[@Innozant]

Aap Innozant website visit karke upcoming batches ka detail le sakte hain ya contact no. Par call karke .

[@sandhyatripathi8175]

If ke sath or ya and lgana same chiz h ?

[@Innozant]

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 .❤️👍

[@dhakafady774]

sirrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
please give a detail playlist about DAX

[@Nitesh-sq7ci]

Sir jb hum(and) ka use krte to cell ko frize krna jarori hai na ye hi and ki pehchan hai na...?

[@Innozant]

Nahi..Freeze ka and or se koi lena nahi hai.

[@Nitesh-sq7ci]

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

[@Innozant]

Ctrl + backspace

[@Nitesh-sq7ci]

Jb Kisi cell ko frize krna ho ...f4 pres krte hai but laptop par frize nhi hota hai ....?

[@Innozant]

Laptop par function key ke saath f4 press karenge

[@ManojKumar-rm9pi]

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

[@narenderyadav1727]

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.

[@Innozant]

Weekend Batch is running for sql .You may contact us for further detail on 7065069985

[@akhilverma4368]

Sir freeze kese krte hai, uski short key ky h?
Please tell.

[@Innozant]

F4 ..aap basic excel ke pehle video se seekhna start kriye .

[@qasikhan]

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)

[@राहुल-ध2ङ]

👍

[@Innozant]

Thanks Rahul

[@vashupathak723]

Sir apka paid course kaise milega online...

[@Innozant]

Innozant website visit kariye ..wahan video course available hain ya aap live class join karna chahte hain to Innozant team se connect kariye

[@Abdulwaheed-pp1nj]

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

[@AlimKhan-bl5sh]

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😂

[@sajidmollick1117]

❤️❤️❤️❤️❤️❤️

[@Innozant]

Thanks Sajid❤️🙏

[@farhanilyas12]

May I ask Sir, aapke Qualification kya hai, what is your profession?

[@aathketahath7155]

Pdf to word word se excel kese krte h sir

[@Innozant]

Video hai already channel par iska dear