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

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

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.



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[loganleger]

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

[loganleger]

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?

[cracker]

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

[wayneedmondson]

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

[aayushnarway]

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.

[mikshubhatt]

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

[akinodequadri]

These are the same functions in coding too

[vyramuthuthiyagalingam]

It's very useful 👍. Thank you so much

[styammishra]

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

[GoGetSP]

AT 3:32 when I enter a negative number i.e =AND(-78) it still gives TRUE?

[kartik]

sir plzz explin use of this all conditions

[amiraboodi]

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

[learnwithshubh]

what is the use of TRUE and FALSE functions?

[mastixmastix]

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

[mehdijj]

thanks for your helpful uploads .. cheers :)

[sambhavjain]

we have to learn these logical formula ?

[amanullaal]

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

[iam_bharat_goswami]

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

[shubhamshoryabhatt]

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

[heeyaboruah]

9:51 =IF(A2<10, "RIGHT", ) there is a comma before the end bracket I don't know if that is intentional either