Using IF with AND, OR and NOT functions, in Excel | MS Excel Bangla Tutorial | Sikkhon

in the tutorial we will show how to use the IF with AND, OR functions together in Excel. add multiple conditions and returns true if they all the conditions evaluate to true.
Used "OR" when evaluating multiple conditions. Returns true if any or all of the conditions are true. Returns false if all of the conditions are false.
For more Info, please visit: sikkhon.com
Support: support.sikkho...
** Sikkhon is an online learning and earning platform for all. **
👇👇👇👇👇👇👇👇
✔️ MS Word Full Course Bangla
(মাইক্রোসফর্ট অফিস ফুল বাংলা টিউটোরিয়াল):
🎵 Watch Videos: • Microsoft Word Full Co...
***************************************
✔️MS Excel Full Course:
🎵 Watch Videos: • Microsoft Excel Tutori...
***************************************
✔️PowerPoint Bangla Full Course
(পাওয়ার পয়েন্ট টিউটোরিয়াল)
🎵 Watch Videos: • Microsoft PowerPoint F...
***************************************
✔️Photoshop Full Course Bangla:
🎵 Watch Videos: • Adobe Photoshop Full C...
***************************************
✔️Adobe Illustrator Full Course Bangla:
Watch Full Course: • Playlist
Why not follow us here for regular updates:
Facebook Page : / sikkhon
If You Like This Video... Pls Don't Forget To Like, Comment & Share in Your Favorite Platforms...
ভিডিও গুলো ফেসবুকে শেয়ার করে অন্যদেরও দেখার সুযোগ করে দিবেন | আশা করি আমার চ্যানেলটির সাথেই থাকবেন |
#msexcelbangla #UsingIF #sikkhon
==============================================
if and or function in excel,
Using IF with AND, OR and NOT functions,
Using IF with AND, OR and NOT functions ,
Use the IF function with AND,
Excel formula: If this AND that,
Can you combine if and/or functions in Excel?,
How do I do an IF THEN formula in Excel?,
How to use the Excel OR function,
IF AND in Excel: nested formula, multiple statements,
Excel IF Formula: Simple to Advanced,
Excel IF statement with multiple AND/OR conditions,
How to use the IF function,
How to Use Logical Functions in Excel: IF, AND, OR, XOR, NOT,
if function with 3 conditions,
excel if statement multiple conditions range,
if function with 3 logical tests,
how to use if and or functions together in excel,
if and string in excel,
excel if(not),
Excel tutorial bangla/ free learn ms excel course bangla,
excel course bangla,
Excel tutorial bangla,
Excel bangla tutorial,
এক্সেল শিক্ষা বাংলা-Learn excel in bangla tutorial,
sikkhon,
Learn MS Excel In Bangla With Free Video Tutorials,
excel if a = b,
how to add and function in excel,
How to Make an Excel IF Statement,
excel,msexcel,excel if with and,microsoft excel,if function in excel,and function in excel,if function in excel 2007,ms excel,excel 2016,excel 2013,excel 2010,examps of if function in excel,excel online course,if excel,excel if,excel 365,excel 2019,excel 2007,ecdl excel,excel help,if function excel greater than,excel graphs,excel formats,excel by miriam,excel if formula,formula if excel,excel for office,excel if function,excel if statementl,excel calculations,excel tips and tricks,
ms excel best 5 tips and tricks,
ms excel bangla tutorial 2019,
how to make a data entry form in excel,
ms excel best bangla tutorial,
ms excel 2007 bangla,
ms excel tutorial,
ms word bangla,
excel tutorial pdf,
microsoft bangla,
Microsoft Excel Bangla Tutorial,
excel bangla tutorial,
microsoft excel,
excel 2010 bangla tutorial,
excel 2007 tutorial bangla,
excel 2013 bangla tutorial,
excel free course bangla ,
excel free bangla tutorial,
excel learn excel bangla,

[@ratnabolinarmadadevidasi6092]

এটা খুবই গুরুত্বপূর্ণ একটি লেকচার ছিল। আপনি খুব সুন্দর করে সহজভাবে বুঝিয়েছেন। ধন্যবাদ আপনাকে।

[@Sikkhon]

ধন্যবাদ, ভিডিও শেয়ার করে ও আমাদের Facebook পেজটি লাইক করে আমাদের সাথে থাকুন । facebook.com/sikkhon

[@mdhamid6956]

vaiya samne aro video video diben asa korchi. apnar video gulu khub helpful. Thanks a lot of for such great work.

[@Sikkhon]

Thank you very much! Samne aro video asbe. Please like our facebook page also facebook.com/sikkhon

[@rahadislam9858]

Finest lecture. Useful for everyone. beginner to advance level. Thank you Sir.

[@Sikkhon]

Thanks a lot. Please subscribe our KIDS channel kzbin.info

[@Sikkhon]

Thanks for liking sikkhon. Amader kids er channel ti subscribe korar onurodh roilo kzbin.info

[@rahatulhossen7765]

It was a very important lecture. You have explained it very nicely and simply. Thank you.

[@Sikkhon]

Thanks for your notes. You can find our free and premium courses at sikkhon.com and post your query at support.sikkhon.com/support/discussions if you need further support.

[@mdal-amin9762]

Alhamdulillah ,,, After A lot of time later I have Cleared If condition(and, Or , Not ),,, Thank You so much sir ,,,, Really Appreciated From Your Tutorial

[@Sikkhon]

Thanks a lot. Please share our videos and like our Facebook page also facebook.com/sikkhon

[@sksobujkhan7720]

sir apnar tutorial dekhe ami onek upokar peysi thanks

[@Sikkhon]

Thanks a lot. Please like and share

[@mhiariful3885]

So help full video brother,May Allah bless you for help us.❤️

[@Sikkhon]

Many many thanks. please like our facebook page also facebook.com/sikkhon

[@mnain033]

all video are excellent and interesting hope more fracture will be discuss

[@Sikkhon]

Thanks a lot... please like and share our videos. Www.facebook.com/sikkhon

[@G_ShihaburRahman_]

Respect kore boltesi as a muslim, starting a hi bola theke salam dile aro vlo hoto onek, tutorials gulo onek effective , good job

[@Sikkhon]

Thanks please visit our website sikkhon.com to get latest videos

[@goutambanerjee6733]

tutorial খুব সুন্দর ভাবে বোঝানো হয়েছে। excellent sir. advance label এর টিউটোরিয়াল পেলে ভালো হয়।

[@Sikkhon]

Glad to hear that! Please like our facebook page also facebook.com/sikkhon

[@sudiptabanerjee5655]

Very good tutorial Sir I want teacher leave statement calculation with medical leave half pay leave commuted leave in all details tutorial please🙏🙏

[@Sikkhon]

ok. sugroi dewar bebostha korbo. Please share our videos and like Facebook page also facebook.com/sikkhon

[@tameemahmad49]

thank u so much...

[@Sikkhon]

Thank you very much! amader fb page ti like kore rakhun latest update er jonno. facebook.com/sikkhon

[@Apuapu51]

ধন্যবাদ

[@Sikkhon]

Thank you. Please like our facebook page also facebook.com/sikkhon

[@h.rpharmacistacademyandhea862]

So nice

[@Sikkhon]

Thanks Please amader kids er channel tio subscribe kore rakhun. kzbin.info

[@farjanajakitania4069]

Ami regular shob video dekhchi... alhamdulillah ami onk kisu jani ...Excel er bpr e amr dharona silo na... Bt akhn beshi beshi practice korte j qstn lagbe kivabe korbo ??

[@Sikkhon]

ধন্যবাদ আমাদের ভিডিও দেখার জন্য, আপনার যেকোনো প্রশ্ন আমাদের forum এ করুণ। forum.sikkhon.com/

[@farjanajakitania4069]

@@Sikkhon আমি নিয়মিত চর্চা করতে চাচ্ছি,কিভাবে অফিসিয়াল কাজগুলোর প্রশ্ন সংগ্রহ করতে পারি ???

[@mdosmangoni050]

Good brother

[@Sikkhon]

Thanks please visit our website sikkhon.com to get latest videos

[@arafat5775]

thanks

[@Sikkhon]

Thanks please visit our website sikkhon.com to get latest videos

[@rahinahmed8986]

Vaiya jodi.. Half time and full time 2 taii condition thake tyle kivabe ki hobe?? Kindly boilen

[@Sikkhon]

Tahole multiple condition hobe.

[@rahinahmed8986]

@@Sikkhon tahole ki full time r por and diye half time boshale hobe??

[@uchsasdevnath9031]

ভাইয়া ভিডিও সুন্দর হলো! কিন্ত হযবরল-এর মতো হয়ে গেলো। যদি আলাদা করে সব বুঝাতেন তাহলে আরো ভালো হতো

[@Sikkhon]

Aro alda alada vai... ok next theke mathay rakhbo. Share our videos

[@uchsasdevnath9031]

@@Sikkhon ধন্যবাদ❤

[@uchsasdevnath9031]

@@Sikkhon ধন্যবাদ❤

[@aliislamictopic]

Excelent

[@jomshedislam5168]

Sir please Index,match and offeset কি কেন,অফিসে কি কাজে লাগে,বেশ কিছু উদাহরণ সহ লম্বাকরে একটা ভিডিও বানান,আমি অনেক ভিডিও দেখেছি কিন্তু বুঝে আসছেনা একদম,প্লিজ স্যার

[@Sikkhon]

Ok. Sigroi dibo

[@jomshedislam5168]

অপেক্ষায় রইলাম স্যার😍

[@MdSohel-oz5gw]

ভাই। আমার একটা প্রশ্নের সমাধান করে দেন। ধরেন, school লেখাটা থাকলে ৫০০ উটবে এটা কিভাবে করতে হবে। এটা কি if দিয়ে করা যাবে? করা গেলেও কিভাবে করতে হবে একটু দেখিয়ে দেন প্লিজ। 🙏🙏🙏

[@Sikkhon]

Thanks please visit our website sikkhon.com to get latest videos

[@awladhossain3772]

Nice

[@Sikkhon]

Thank you! Please like our facebook page also facebook.com/sikkhon

[@sayedjakir8321]

Hello brother Online job apply korar somoy photos ; signature and documents kibabe upload korbo Doya kore details bole ekta video den.

[@Sikkhon]

ok. samne ekta video dibo in sa allah.

[@sayedjakir8321]

@@Sikkhon bhai sombob hole ektu joldi diben. Don't mind please.

[@Sikkhon]

Ok

[@Sikkhon]

Please check video. asa kori apnar problem somadhan hoye jabe. na hole janaben abar kzbin.info/www/bejne/rJrEknZmop5obtU

[@sayedjakir8321]

@@Sikkhon ok thanks brother

[@sumonmozumder4208]

ভাই আপনিতো এখানে দেখাইছেন Or দিয়ে শুধু Full-time যারা কাজ করছে তারের ভনাজ দেয়ার সিস্টেম আমরা যদি Full-time and Halftime দুজনকে দিতে চাই তাহলে কিভাবে দিতে হবে? এটা একটু ভিডিও বানিয়ে বলেন!

[@Sikkhon]

then use two if formula

[@Elsewhere_92]

good

[@Sikkhon]

Thank you very much! amader fb page ti like kore rakhun latest update er jonno. facebook.com/sikkhon

[@eliashossain4232]

ভাইয়া, একই সাথে ২টি Row কিভাবে freeze করা যায়, সেটি দেখাবেন

[@Sikkhon]

Ok. Ekti video kore dewar cesta korchi. Please shere our videos

[@eliashossain4232]

@@Sikkhon ji share koreci, r opekkhay roilam

[@amitbasu9321]

Result sheet a %mark decimel a doi ghor er beshi jeno na ase seta kivabe function korbo?

[@Sikkhon]

please check this forum post support.sikkhon.com/support/discussions/topics/101000612342

[@Crazy_Wishes143]

Vii amr if and ai function gulo kj korca na, thik vaba e sutro bosai bt hoy na, setting pblm Mona hoy, ki korbo akn

[@Sikkhon]

there is not any setting for IF function. please check your formula again

[@chetanachatterjee2534]

Sir ms-exceler modhey je itd ache. Sai itd ta basic Salary diye hobe. Na gross salary diye hobe. Abaro kichu khatra itd Designation diye hoy. Seta ki company rules onujai hobe. Na ki gross salary diye hobe na basic salary itd diye hobe ektu bole dile valo hoy

[@siamahmed275]

vaiya employer er sellery 20000 er upor hole , se tar 10% bonus pabe...na hole pabe na...ai function ta korbo kmne!

[@Sikkhon]

Ei videor surutei to ache. Video te dekhano hoyeche 25000 er upore hole 4000 pabe. Jekhane 4000 diechi sekhane hobe d4/100*10 . Na parle abar janaben. Thank you

[@siamahmed275]

@@Sikkhon =IF(H3>27500,"h3/100*10","0") ai formula use korchi,, hosshe na tw sir...result a ashce h3/100*10 ta......nmbr ashce na.....

[@Sikkhon]

Apnar file ta facebook.com/sikkhon ei jaygay message korun. Ekhane somvoboto "" kete dite hobe. Apni file ta send koren. Dekhe dicchi

[@zarifrasel4193]

ভাই Vlookup এর কাজটা দেখান।আজ জব ইন্টারভিউ তে জিজ্ঞাসা করছে। জানি না দেখালে অনেক উপকার হতো

[@Sikkhon]

please check out our MS Excel advanced course sikkhon.com/courses/advanced-ms-excel-functions-formulas/

[@Waliullah95]

If function a kivabe a number bosabo jemon ami chai jodi "A5" cell a value 1 theke 8 thake tahole result 8 hobe, and jodi 8 er upor theke 16 thake thaole 16 hobe. Ei formula ta if function diye kivabe sajabo please

[@Sikkhon]

please check the forum post support.sikkhon.com/support/discussions/topics/101000612417

[@forhadhossainabir9627]

bepok important ekta jinis dekhailen...

[@Sikkhon]

We’re so glad you’re finding value in Sikkhon! Take a look at our premium courses at sikkhon.com when you’re ready for more. And don’t hesitate to reach out if you need assistance!

[@zakirhossain4196]

How can I use AND & OR function together after IF function. Suppose Job Type is Full Time and year>3 or sell>20000 then I should I write the function?

[@Sikkhon]

Please submit your query through our forum by visiting - support.sikkhon.com/support/discussions. Please make sure to mention the title of the video/course your query about. Our support forum team will reply to your post as soon as they are available. If you haven't used the support portal before, you may need to register for support portal for the first time. Please make sure to provide as much details as possible including screenshots and short clips, if you may have related to the issue. Thanks in advance.

[@milonhossain7803]

আমার একটা প্রশ্ন আছে ধরেন একটা কোম্পানি ৪ শর্ত আছে একটা শর্ত পুরন করতে হবে আর বাকি তিন টা শর্ত মধ্যে একটা পুরন করিলে হবে তখন কি সূত্র ব্যবহার করা হবে

[@Sikkhon]

use multiple if for that or share your sample file to our forum support.sikkhon.com/

[@md.masudurrahman3799]

স্যার, যদি বলা হতো ; সেলস যদি ২৫,০০০ টাকার বেশি এবং চাকরির বয়স ১ বছরের বেশি হয় তাহলে সেলস এর ৫% বোনাস পাবে, তাহলে ফাংশন টি কি হতো???

[@Sikkhon]

Thanks for your query. You can post your query atSikkhon Support Portal [support.sikkhon.com/support/discussions]for further support, also can find our premium courses by clicking on this link [sikkhon.com/]sikkhon.com/ [sikkhon.com/].

[@atikunnabi3570]

আপনার পূর্বের ক্লাসে ইফ এর ব্যবহার আছে, কিন্তু এলস এর ব্যবহার নাই

[@Sikkhon]

Thanks for your notes. You can find our free and premium courses at sikkhon.com and post your query at support.sikkhon.com/support/discussions if you need further support.

[@al-aminahmed9]

ভাই আমার Excel এর মধ্যে এই সূত্র দিলে কাজ হয় না , the formula you type contain an error এই লেখা টি আসে ,এই সমস্যা সমাধান কিভাবে করবো দয়া করে জানাতেন

[@Sikkhon]

Please submit your query through our forum by visiting - support.sikkhon.com/support/discussions. Please make sure to mention the title of the video/course your query about. Our support forum team will reply to your post as soon as they are available. If you haven't used the support portal before, you may need to register for support portal for the first time. Please make sure to provide as much details as possible including screenshots and short clips, if you may have related to the issue. Thanks in advance.

[@idcreat8565]

Brother, please skip the word 'hi'. This is very annoying. Either give 'salam' if you are a Muslim. Needless to say

[@Sikkhon]

i already stop saying hi for all of my members 🙂🙂

[@abukawsar7553]

Excelent

[@Sikkhon]

Thanks. Amader kids er channel ti subscribe korar onurodh roilo kzbin.info