[FREE Excel Course] Lesson 10 - Logical Formulas in Excel

Рет қаралды 142,638

5 жыл бұрын

In this video of this Free Online Excel Training, you will learn about the following logical formulas:
-- AND function
-- OR function
-- NOT function
-- TRUE function
-- FALSE function
-- IF function
-- IFERROR function
-- IS function
☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: trumpexcel.com/learn-excel/
You can also access the Full Excel Training on KZfaq here: • Getting Started with E...
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: kzfaq.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 53

@loganleger6642 Жыл бұрын

If I can ask one question about this video lesson: what are these formulas used for? What kind of situations would he have to use this in real life?

@loganleger6642 Жыл бұрын

Hello Sumit. Thank you for your guidance and sharing of knowledge in these Free Excel Courses. Your training is greatly helping me develop my Excel skills as I search for full-time employment out of university

@akinodequadri43 4 жыл бұрын

These are the same functions in coding too

@prashant3492 3 жыл бұрын

so genuine work i have ever seen.

@iliesboukhatem7803 2 жыл бұрын

very useful, thank you so much !

@cracker2352 13 күн бұрын

Hey Sumit the work that you do is pretty Great ❤ Kudos to you 🎉

@sumeetjagtap7647 Жыл бұрын

Loved It, Thank You Sumit.

@mikshubhatt1175 4 жыл бұрын

hey Sumit, you have done a great job keep it up and pls try to avail other courses like VBA ASAP.

@styammishra3209 2 жыл бұрын

thankuu dude, good job and you're earning genuine money

@wayneedmondson1065 5 жыл бұрын

Hi Sumit.. thanks for the logical formula review and for offering this series for free. Thumbs up!

@heeyaboruah9226 3 жыл бұрын

You could also add the emoji but this was one year ago so it is okay, comparing today with last year so much changed

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks for the this course.

@aygunsafarova3079 3 жыл бұрын

Thank you very much.

@eliasgivans7973 8 ай бұрын

Thanks Sumit

@aayushnarway248 3 жыл бұрын

Hi Sumit, thnx for the series. I want to clarify that any non-zero number is considered true. It doesn't whether they are positive or negative.

@yuvrajahuja1857 2 жыл бұрын

Thanks

@amiraboodi2075 2 жыл бұрын

Thank you very much, Summit. Like always, it was clear and informative. 🤗

@mehdijj4550 4 жыл бұрын

thanks for your helpful uploads .. cheers :)

@FRANKWHITE1996 5 жыл бұрын

thanks

@amanullaal9531 10 ай бұрын

I am confused as to why these logical formulas are explained. It seems no use in practice.

@mastixmastix Жыл бұрын

So what is this for? Any samples when this could be useful?

@kartik1908 2 жыл бұрын

sir plzz explin use of this all conditions plzzzzzzzzzzzzzzzzzzzzzzzz

@iam_bharat_goswami Жыл бұрын

This is soo much confusing for me is there any way i can understand it better?

@sambhavjain1915 Жыл бұрын

we have to learn these logical formula ?

@learnwithshubh3820 3 жыл бұрын

what is the use of TRUE and FALSE functions?

@hash_caul976 2 жыл бұрын

Same question , I watched full video didn't understand what's true or false motive

@Tech4Geeky Жыл бұрын

@@hash_caul976 yaa same thing guys in real life will it be help full??😅

@hash_caul976 Жыл бұрын

@@Tech4Geeky It's not helpfull at all in real life....

@Ash_Ak Жыл бұрын

@@hash_caul976 then i will skip this class.LOL😁

@hash_caul976 Жыл бұрын

@@Ash_Ak learning never waste brother

@samantamonaci9682 4 жыл бұрын

Can't understand the use of those, what are they for?

@heeyaboruah9226 3 жыл бұрын

Use of what? Excel? Excel is really helpful, like so helpful you don't even know so I don't know what you are talking about.

@samantamonaci9682 3 жыл бұрын

@@heeyaboruah9226 I'm not talking about excel of course 🙄 talking about this lesson

@heeyaboruah9226 3 жыл бұрын

@@samantamonaci9682 It could be useful in many ways you just need to try out different things to find out where it could or would be used. Like this would be very helpful in experiments or any math work you have to do in school or if you an adult if you need it in your job.

@heeyaboruah9226 3 жыл бұрын

And as someone in the comments had mentioned, it can be used in coding too.

@ksi4692 4 жыл бұрын

i'm confused as there is no context

@heeyaboruah9226 3 жыл бұрын

??? I am confused with your comment

@chelseafc2108 3 жыл бұрын

this is lesson 10 bro. If you want context, start from lesson 1?

@PB-9697 3 жыл бұрын

why does NOT function reverse the argument and where is it used?

@heeyaboruah9226 3 жыл бұрын

because it is NOT what it is saying

@heeyaboruah9226 3 жыл бұрын

It like working with negative and positive integers, well somewhat like that

@shubhamshoryabhatt9069 4 жыл бұрын

All videos were good but couldnt understand a single thing here may be i am dumb

@heeyaboruah9226 3 жыл бұрын

I am in grade 7 and I understand so.... I think you may be dumb............

@ayushahuja8983 3 жыл бұрын

@@heeyaboruah9226 you are dumb no doubt brother

@financicalliteracyIND 2 жыл бұрын

ACTULLY YOU WILL UNERSTAND WHEN YOU DO MARKSHEET OR SALARY SHEET ETC AND THERE YOU FIND IT HELPFUL AND THEIR PRACTICAL USE, OTHERWISE IT'S ALL CONCEPTS

@rajvideocreations Жыл бұрын

14:51

@heeyaboruah9226 3 жыл бұрын

9:51 =IF(A2

@yash9625 3 жыл бұрын

Yes that's intentional to show if nothing is specified when the condition gets failed by default excel returns 0.

@heeyaboruah9226 3 жыл бұрын

@@yash9625 Thanks

@Gonnaremember Жыл бұрын

What a waste of time I thought it's excel training now I found it's logical operators lesson after half way after a busy schedule this is very upsetting. As excel already showing all the results correctly then why do I need to learn how it happens. My question is will these type of questions be asked on excel exam.

@heeyaboruah9226 3 жыл бұрын

9:51 =IF(A2>10,,"WRONG") I don't know if it is intentional but there are two commas you might want to fix that by the way but thanks for the video!

@financicalliteracyIND 2 жыл бұрын

YES , HE INTENSIONALLY DID THAT TO AVOID THE ARGUMENT--"VALUE IS TRUE"