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

[@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

[@cracker2352]

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

[@akinodequadri43]

These are the same functions in coding too

[@wayneedmondson1065]

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

[@heeyaboruah9226]

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

[@aayushnarway248]

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.

[@prashant3492]

so genuine work i have ever seen.

[@mikshubhatt1175]

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

[@vyramuthuthiyagalingam7935]

It's very useful 👍. Thank you so much

[@sumeetjagtap7647]

Loved It, Thank You Sumit.

[@styammishra3209]

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

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@kartik1908]

sir plzz explin use of this all conditions plzzzzzzzzzzzzzzzzzzzzzzzz

[@yuvrajahuja1857]

Thanks

[@amiraboodi2075]

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

[@eliasgivans7973]

Thanks Sumit

[@amanullaal9531]

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

[@iliesboukhatem7803]

very useful, thank you so much !

[@GoGetSP]

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

[@learnwithshubh3820]

what is the use of TRUE and FALSE functions?

[@hash_caul976]

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

[@ksi4692]

i'm confused as there is no context

[@heeyaboruah9226]

??? I am confused with your comment

[@chelseafc2108]

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

[@iam_bharat_goswami]

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

[@samantamonaci9682]

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

[@heeyaboruah9226]

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]

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

[@heeyaboruah9226]

@@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]

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

[@aygunsafarova3079]

Thank you very much.

[@shubhamshoryabhatt9069]

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

[@heeyaboruah9226]

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

[@ayushahuja8983]

@@heeyaboruah9226 you are dumb no doubt brother

[@financicalliteracyIND]

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

[@mehdijj4550]

thanks for your helpful uploads .. cheers :)

[@mastixmastix]

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

[@sambhavjain1915]

we have to learn these logical formula ?

[@heeyaboruah9226]

9:51 =IF(A2

[@yash9625]

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

[@heeyaboruah9226]

@@yash9625 Thanks

[@PB-9697]

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

[@heeyaboruah9226]

because it is NOT what it is saying

[@heeyaboruah9226]

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

[@rajvideocreations]

14:51

[@heeyaboruah9226]

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]

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

[@FRANKWHITE1996]

thanks