Excel Logical Function-OR function , AND function
Вставка
- Опубліковано 13 жов 2024
- 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
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/n.gif)
Sir, me apka sikhane dedication dekh kar me apko salute karna chahta hu.
Boss always boss salute for innozant team and 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..
Value for Money style of teaching.... Ek ek topic crystal clear... Thanks
Thanks Khan Sahab..Really means a lot to me..Happy learning
College me tha tab sikha tha Digital Electronics subject me AND & OR. Aaj acche se samjh aaya.
Thanks dear❤️
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 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
Aap bahut achha concept clear karto ho..
Thanks Rahul
Thanks Sir, you are Brilliant and Superstar of India, you are serving the People,
Best channel for Excel on UA-cam......superb content ❤
Thanks ..Keep Learning
Best channel to learn excel. This channel helped me pass my excel test for the job. ❤
Thanks
Thank you so much sir. AND, OR ki confusion duur krva dii apne meri.
Thanks Anil 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👍
Bahut achha se explain kiya sir aapne
Thanks
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
Bhai..mein to apka fan hogaya.. wo v jabra..🤗
Hahahaha.mThanks Sayed..God bless you❤️
Very Very Helpful Sir Thankyou So Much
Thanks Suraj
Sir Ur my bestest teacher
Thanks
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
Very nice way to teach.
Thanks Shwet👍❤️
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
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
Explain nicely..useful for beginner learner.
Very well explained
Beautiful style of teaching
Thanks Aatif sahab
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
By this way of teaching, even a baby in the cradle can be taught
Thanks dear❤️❤️♥️👍
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 ?
Excellent way of teaching...simply great
Thanks dear
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👍
Nariyal chill diya sir is video me bhi......💕❤️❤️❤️❤️
hahahaha..Thanks Devender ji
Keep it up sir.. Very useful function.. Thanx...
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?
very use full function🙏🙏👍🏻👍🏻
Crystal clear sir thanks 👍
best sir for excel
Sir can we use ifs function in this rather than if (or) function
Good teaching abilities.
I salute your way of teaching, Superb
Thanks Rahul..God bless you..Happy lead 🙏❤️
best teacher
awesome video
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
Thanks Sir.
Good explain
Thank you sir
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
Thank you🙏🙏🙏🙏 sir very very thank you
Great sir ji
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
Requesting to do multiple criteria matches with if and AND
👍
sir if function wali files mill gyi practical assignment mai se thank you
👍❤️
How to set if formula if I divide and it comes whole number then 1 multiple else next colum value
TQ...SIR...🙏🙏
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.
Just awesome sir.
Thanks dear
Sir please make a video for Searchable Dropdown list(data in a table and using vba code).
Haan ye bana dete hain jald
Thanks u sir
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.
Plz try to explain excel course I zoom in position, so that we could easily understand. Thanks
Dear Deepak..Thanks for your suggestions.noted
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 ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
Sir.ji amazing 😆
Thanks Sanoj ji
Best class
Thanks dear
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
Thanx sir
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
Thnq sir ji
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
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
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 .
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
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 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
Very very much
Sir, Ye Ham IFS se v kar sakte hai.
Yes
Brilliant teaching 👍 always
Thanks dear...Happy learning dear
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
Sir aap online bhi padate ho
Yes ..kindly connect with team innozant
Sir
If A=1 then value 0.6, if A=10 then value 0.9 , if A >1 or
Nice
How to apply if and Vlookup functions in Excel ?
Kindly Watch lookup series
Hi Sir
I need little help on one topic!!How can I send you my sheet
@innozantofficiap.telegram id
@@Innozant Sent on the telegram.
Nice bro
Thanks
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 .❤️👍
Thank you🙏 oo sir gg
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
sirrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
please give a detail playlist about DAX
Sir freeze kese krte hai, uski short key ky h?
Please tell.
F4 ..aap basic excel ke pehle video se seekhna start kriye .
👍
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 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.🙏🙏🙏🙏
Jabardast
Thanks
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
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 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 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
May I ask Sir, aapke Qualification kya hai, what is your profession?