MS Excel | IF Function

[@arwinweenink2846]

Thank you, sir! I'm writing practical tomorrow and this is really helping!

[@YHWHs_D]

May Christ bless you abundantly Mr Long. Thank you

[@Dxviddddd]

All my life I've been doing it the long way, but I've changed! I'm going it the Mr long way, it's less time consuming😌

[@ntokozomngomezulu4620]

I have a big test tomorrow and I’m pretty sure I’m gonna nail this function😊you make it so easy to understand

[@MrLongITandCAT]

Glad the videos can help! Good luck for that test!

[@Gaigeyboy_23]

You dont understand how much you help, thank you Mr Long way🙌😌

[@MrLongITandCAT]

I'm so glad the videos are useful. Thank you.

[@BokangSin]

Thank you very helpful content for my test Tommorow 😃

[@MrLongITandCAT]

Hope the test went well!

[@kristenbrand8649]

Writing practical today and wanted to review. I could not remember anything and was like ugly crying. This helped to ease my mind.

[@MrLongITandCAT]

I'm glad that I can help :)

[@brysonrampersad606]

Hi can you make a video on how we would address a 3 way IF statement.

[@MrLongITandCAT]

Does this video help: kzbin.info/www/bejne/a5i9qmeElMqhmsU

[@brysonrampersad606]

@@MrLongITandCAT yes thank you

[@NobuhleMahlangu-s7v]

Hey Mr Long, how do we do it if in the second part of the formula (if false) isn't supposed to change the value?

[@MrLongITandCAT]

you can leave it as blank then or double quote double quote for nothing

[@Ogone26]

Hey Mr Long I tried the =SUMIF(C4:C23;"F";E4:E23) formula for the "total amount raised by females" and it gave me 0 and same goes for the =SUMIF formula for "total amount raised by those with 6 or more points" Why does it give me 0 as an answer?

[@MrLongITandCAT]

It could be that the data in column E is not a number data type. It may look like numbers but the format may be set to Text

[@AFKFarmer_Lee]

these are the most helpful videos in my grade 11 CAT... only problem is i hate studying and ive been studying for 3hours straight... can someone help me ;_; also at 7:30 in the video you give an example, what happens if you want to multiply the value with another value that's maybe in cell E1 and want to copy the formula without changing cell E1, do you use absolute cell referencing and if so, do you put $ around the formula or around the letter i keep forgetting nvm that got answered quick... new question, does a formula IFS work and if it does, how does it work?

[@JamesSwartz123]

bro went to a Jay z concert and pulled up the illuminati sign.😑😑😑

[@MrLongITandCAT]

Shine bright like a diamond :)

[@JamesSwartz123]

@@MrLongITandCAT no no don’t sugar code it now mr long😭 it’s alr bad enough that you pulled up the illu sign😭

[@doodfromacrossthastreet]

IEB Final tomorrow, are we cooking or are we cooked?

[@D.T.Dz1_38]

We are cooking