Excel Logical function - AND function, OR function | Excel in Hindi

1. Excel Logical functions with example
2. logical function in excel
3. logical functions in excel 2007 with examples
4. AND Function in Excel
5. OR Function in Excel
6. Excel Logical function
7. logical function definition
What are the Logical operators?
What is the definition of logical functions?
Excel Logical functions with Examples pdf
excel logical function exercises
How to use Logical Function?
Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
Excel Logical function - AND function, OR function | Excel in Hindi
To watch more videos visit: www.excelsupers...
To Buy a Excel Course Pen drive visit: www.excelsupers...
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar

[@ExcelSuperstar]

Get 100% OFF on Excel Interview Essentials course *Use Coupon Code - ESSJUL20*
Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ

[@princesj5526]

I don't understand!! in OR function, when you used OR(B5="Male", C5>=45)
Why the resulting age 40 comes (TRUE)?!!

[@Sarfu1]

I came to your channel first time and I liked to your teaching style.

[@amitdixit7339]

Wah sir jesa aapne samjhaya h waisa aaj tak nhi samjhaya kisine 🙏thank you 🤗

[@vanshmaru02]

You have very gentle attitude sit..god blese..

[@muhammadbilal3900]

Amazing teacher. Thnx to you tube, cross border learning is possible

[@pulakkalia]

very simple and helpful video. teaches right from the scratch. thank you very much.

[@surajbhardwaj428]

Kamal ke ho bhai app👏👏. Maje mai sikhate ho.. asehi sir ki khoj thi mujhe.🤗

[@deepalikamble3721]

Osm you are Boss sir 😊

[@SunilKumar-kn8hv]

बहुत अच्छा लगा सर ।

[@girishvohra9803]

Sir awesome video. Thank you sir

[@moodkn]

Thanks... Very Helpful

[@flipzonewala]

👌👌👌amazing

[@divyagow2756]

Its so helpful.and your teaching was learn to easily

[@ShaibulHoqueMozumder]

Always you great sir

[@dakshkumar873]

Thank you Sir. 😊👌

[@kajalkansal4233]

i llike your all vedio.

[@rupeshpandya9590]

Amazing knowledgeable, and EK BUTTON IDHAR AUR EK BUTTON IDHAR 👌😊

[@MultiDpz]

Click Click :D

[@Anujkumar-sh3ph]

Aapki Video Mujhe Bahut Achhi Lagi Hai sir g

[@anudhiman3339]

Thanku sir so muchhh

[@AbhishekKumar-fm6dn]

Very good sir 😲😲😲😲😲

[@saquibsher]

Superb.

[@shraddhapandey7024]

Thanks sir

[@umeshmishra2010]

very nice idea have u sir

[@rajeshkumargupta8371]

Thanks

[@abbasshah6464]

Thank you sir for help but i request you to make any project like attendance sheet, or inventory sheet or any other where these formula used

[@sufalgautam2188]

Very Interesting, The way of teaching,the way to connect additional clip for fun Finally LIKE bada wala

[@amangandhi1130]

Good👍

[@mrs.bawarchi8929]

Thank you sir

[@samtechtv146]

Good #knowledgezone

[@umarajawat2478]

you taught very well

[@mahaboobhossain5076]

great brother

[@jitendramaurya7320]

sir one Question excel me key bard se columns & raw ko kaise hide &show karenge plz tell me sir very importaint h

[@ranibag6105]

Tqqqq sir

[@umershah2733]

Its so helpful... Thanks for sharing :)

[@arvindmevalaljaiswal7234]

Dear sir.
Dropdownlist Mein selected Logon Ko discount dena hai kaun sa formula lagega.

[@babarqureshi5043]

Thanks sir.
Kindly make video AND & OR in conditional formatting.

[@vinay103]

Super

[@ranjuanil]

Sir make a video for multiple cell filled by number count odd and even only no count blank cell or filled by text

[@WeLikeSafety]

Good

[@learnsolo2721]

thanks for the awesome video bro...

[@gunindradas8042]

Please uplode a new MIS report which use in Telecom mainly

[@MsMunmun07]

very nice video..

[@divayasnhdigarse4818]

Too good budy

[@PawanKumar-yz4zf]

superb

[@dharmendarrana4191]

1. Return different values based on condition
Supposing i have a agent total call attend in a month (400) calls and i want to each slab the total incentive based on the following conditions:
Incentive Format
Slab 1 0 - 50 2.50₹
Slab 2 51 -100 3.50₹
Slab 3 101 -150 4.50₹
Slab 4. 151 - Above 10₹
How much total Amount of incentive. By using Excel formulas like as (Nasted IF, choose, vlookup or sumproduct). What will be syntax of Excel formula.
Regards
DHARMENDAR RANA

[@krishnasharma3950]

Sir please make video on macro

[@goodwaysprojects3035]

Is it possible to use if alongwith AND/OR function?

[@yogibala6749]

I have output data generated by formulas in a large table which I need to furnish based on a date parameter and the same should be as value/text in the same table format. I am able to do this by Macro with one click. This table consisting text value is always a smaller one and I want to hide extra rows either with a formula or macro. Please guide.

[@ashish803922]

Very nice video n presentation sir.... bt ek point add karna chaunga, jab aap formula likhna start kare pl cursor ko hata diya kare woh uske uper overlape krta h. Thx n regards

[@Schoolbookidea]

dear sir please make a video on incometax calculation fy 2019-20

[@madurgababueducationS60]

all excel formula video uplood korun

[@vinitgupta226]

Hi Sir,
Kya aap meri help kar sakte hain ki Nested if aur And function mai kya difference hai? Kya ye dono formula ek hi hain?

[@nishikantjoshi8164]

Sir I want to compile a data is not having in sequence and for some seconds there is no transaction which I want to make in sequence and for which seconds there is not data available there value should be reflected as zero or null ? Please guide how it will be possible in excel ?

[@madurgababueducationS60]

all if , and , or , vlookup formula excel video uplood .

[@gunindradas8042]

Sir in a blank row if a value is blank the main total row fill a collor. If put any value then the collor automatically remove. Is it possible. Ex I sum few no. If total mark found by Excel the total row row remove the collor. Is no value found it fill a collor. Please uplode a video

[@arvind_singh_vlog]

V good

[@basantkumarchandola2897]

Please show the formula= if(and(or

[@sonukumarsahani7416]

In the drop down are the following functions:
None
Average
Count
Count Numbers
Max
Min
Sum
StdDev
Var
Other Functions...
When a function is chosen the calculation is shown in that same cell that contains the drop down. And how do I do this??

[@princemorrison3473]

assa hey good luck

[@mdfaizanhere]

Sir
Do cells me alphabets and numerical hain ek me (abc10) or dusre cell me (abcd20) dono cells ko sum karen to 30 aae. Sir ise kese karen?

[@SalmanAli-ud1kc]

ap mujhe batay one cell, like E3 ye mera total wala cell hay is he E3 waly cell me muhe + ka result b chaiye - ka b result or x ka b ho kese ho ga

[@mohmmadirfankhan9408]

SIR "AND" FORMULA ME SARE LOGIC TRUE HONGE TO HI ANSWER TRUE MILEGA KYA , ISKE OPPOSITE "OR" FORMULA ME EK B LOGIC TRUE HOGA TO TURE HI ANSWER MILEGA KYA.

[@anupkumar.2203]

Hi sir, do I get advance Excel full course

[@MHN_SIR_MOTIVATION]

kaise video bnaaye sir

[@TechiTVpk]

where is exercise download button.
fake link

[@laxmikhandare337]

I was trying to skip Ad. 😅😂......

[@ronitbro6952]

92.6
80.36
77.62
63.63
10.55
9.48
6.83
sir in ooper diye gye number me se ese number chahiye ki mera average 53 ya iske aas paas aaye....to kon sa formula use karu sir?

[@meenusehgal2135]

ik br ye explain kr de sir ki excel m logical formulas h kitne

[@AshokSharma-wp7jk]

HOW TO COMPARE 3 VALUES USING IF....WHICH IS GREATER

[@shirishitskills9408]

=IF(AND(A2>B2,A2>C2),"A is highest ",IF(AND(B2>A2,B2>C2),"B is highest ",IF(AND(C2>A2,C2>B2),"C is highest ","no comparision"))) other way also can be used

[@vivideyes4968]

Bhai kia hm Land ko calculate kr sakte hai, i mean 5 Acre 10 kanal 25 marla calculate kr k 6 Acre 3 kanal 5 marla ase likha jata hai, kia excel me hm is ko calculate kr sakte hein??????

[@kapilverma352]

2:07 i like that😂😂

[@cspradhan7745]

Which is not a function in ms excel
And
Sum
Product
Count

[@SANJEETKUMAR-ps5uz]

hamara ago sawal hai video me filemeya kahe dalte hai ubhe kaua biryanee wala

[@suratgarhsingerclub2720]

please sir example big big big le

[@sandipkamdi1597]

Hello sir mera ek confusion h sir, Salve krdo plzz .100,90,80,70,60,50,40,30,20,10 in value me se muze sirf 50 ke uper ki hi value total me add krni h ho kese karenge formala kese lgaye..Plz sir salve thiss

[@rizahmed716]

sumif(range , criteria (50>), sum range)

[@VENOM-nk4qc]

Vai yeh to if function Mai vi hota hai 😅

[@amichael9575]

How to use multiple IF functions
Kindly provide email id

[@ashhadjamil3659]

امی نے بتانے بھت دیر کی😂

[@ExcelSuperstar]

Advanced Excel Webinar v2.0
Hurry up!
Book your seats now(limited seats)
www.excelsuperstar.org/

[@rihan9012]

Super sir sari vedios aap ke top hai ek dam 9756087693

[@vipinrokers9699]

Sir आपका नंबर दीजेए न प्लेज़

[@satyadev4309]

how I call you ???

[@aaliyaansari5569]

Example to sahi to do 😂😂

[@SKR_12_]

Click click..😂😂

[@yashasvisharma6262]

POOR EXPLANATION !!!!!

[@ExcelSuperstar]

Thank you!

[@ShankarKumar-pu4uo]

Thanks sir.

[@kaminidhiman4989]

thanks sir

[@dimpalkaul7949]

Nice

[@madurgababueducationS60]

all if , and , or , vlookup formula excel video uplood .

[@dishakumari7286]

Thank you sir

[@kunalsingha981]

Nice