It's so much better when practical examples are used. MARVELous.

@MyOnlineTrainingHub

9 ай бұрын

😁cheers, Rob! Nice play on words 😉

100/100 for creativity. We all know your excel skills 👍. But I guess acting was even better. Loved it 🤩

@MyOnlineTrainingHub

9 ай бұрын

🤣I'm not sure I'd go that far, but glad you enjoyed it! 🙏

Great explanations and examples! You are a true Avenger of false formulas!

@MyOnlineTrainingHub

9 ай бұрын

😁 thanks so much 🙏

Thanks for the video! It made me smile every now and then, but didn't distract too much of the things you wanted to explain.

@MyOnlineTrainingHub

9 ай бұрын

Glad to hear it, Xander! 🙏

Wow Mynda, you always exceed expectations in your videos - so much I don't know, and loved the humour with Chris, thank you.

@MyOnlineTrainingHub

9 ай бұрын

Thanks for watching and your kind words 🥰

Great video editing and idea is great, very informative thanks.

@MyOnlineTrainingHub

9 ай бұрын

Glad you liked it! 🙏😊

Terrific video, lots of stuff I didn't know as a long-time Excel power user. Thanks!

@MyOnlineTrainingHub

6 ай бұрын

Awesome to hear 🙏😊

Absolutely loved your short yet eye opening sharing about the logical function. Your creativity was at it’s best TH”OR” (nice pick by Vijay)! ❤ it.😍 Thanks for sharing! 🙏

@MyOnlineTrainingHub

9 ай бұрын

So glad you enjoyed it! 😁🙏

Wow! What an amazing quality of excel walkthrough!! I am learning advanced excel as a university course (Finance) and just disocvered your channel. I already loved fooling around excel anyways but this is so interesting. Half of the stuff on your channel I don't even have to learn but I am sure at one point or another it will be beneficial to my career and it's interesting anyways! Great teaching skills and I like the humor in the video as well! Everything is so clear it's truly exceptional!

@MyOnlineTrainingHub

9 ай бұрын

Fantastic to here 🙏 good luck with your studies 😊

This lesson is fantastic.

@MyOnlineTrainingHub

9 ай бұрын

Glad you think so, Michael! 🙏

It's definitely needed for others to see better approaches for using logical tests and brings forward an important modeling point -- structuring your data to leverage the full power of the function is critical. Thank you. A point for consideration: the plus operator (+) is actually an arithmetic operator. TRUE and FALSE are Boolean data types, not numbers. As you mention, this is why the unary operator (--) exists; it explicitly converts the Boolean type to a numeric type. Depending on what we're doing in the spreadsheet, Excel will implicitly convert the Boolean values to bit values (i.e. a number) which can then be used in arithmetic. This is why, for example, when A1 = TRUE and A2 = SUM(A1), you get the value of 0, but when B1 = A1*1, you get 1. (The arithmetic operators are implicitly converting the Boolean type to a number; this is a programming technique for overloading operators). Thus, TRUE and FALSE are not actually 1 and 0. This is also why SQL Server, for example, does not have the Boolean data type; no need to waste CPU time on the data conversion from Boolean to bit. In other languages, the OR comparison operator is often ||. Compliers use the definition that 0 is truly 0, which is why it evaluates to false; by definition, everything else is not 0, or true. The binary notation of values (0 in decimal is 0 in binary) also confirms this point (and everything else in binary is not 0).

@MyOnlineTrainingHub

9 ай бұрын

Thanks for sharing the insights, @BizTrix 🙏😊 This, in particular, was interesting: "Compliers use the definition that 0 is truly 0, which is why it evaluates to false; by definition, everything else is not 0, or true."

Thank you so much. I learned so much. You make complex concepts so simple.

@MyOnlineTrainingHub

9 ай бұрын

Wow, that's great to hear 🙏

Beautiful lesson. Thank you.

@MyOnlineTrainingHub

9 ай бұрын

🙏 so glad you liked it!

Nice way of teaching! 💯

@MyOnlineTrainingHub

9 ай бұрын

I appreciate that, Roger! 🙏

Great video! One challenge though @12:15 Sadly, IFS doesn't appear to stop calculating when it reaches TRUE, unlike the IF function, which DOES stop calculating. You can observe this by creating some IF and IFS test functions and stepping them through the Formula Evaluator. I can have a dozen IFS conditions - and even though the very first one will be TRUE, it still evaluates every single condition anyway (i.e. it doesn't stop). In fact, it's worse than that. You know how we often end our IFS with TRUE (as a catch-all)? Well, you can end your ifs with a dozen TRUE catch-alls, and it will keep evaluating each and every one - it doesn't stop at the first one. For example, end an IFS with ....TRUE, "Done", TRUE, Cos(15), TRUE, Sin(45), TRUE, Tan(90)) and you'll see in the Evaluator that it calculates every one of those TRUEs Anyway, this is why, if I have a large spreadsheet, I now try and avoid IFS 😩

@MyOnlineTrainingHub

9 ай бұрын

Ah, yes I had forgotten that. Thanks for sharing. To be clear for others reading this, while it does calc all tests, it returns the first TRUE, so the order of tests is still important, but it's not more efficient. I dug up an old email thread about IFS which contained a link to this post by Charles Williams about short circuiting in array formulas that might be interesting to others as well: fastexcel.wordpress.com/2023/01/06/short-circuiting-in-array-formulas/

A few notes: 1. It would be useful to start with a truth table for all the functions mentioned (only a percentage of users know XOR, it can crypt/encrypt beautifully). 2. It would be useful to explain more thoroughly the occurrence of --, i.e. (-1)*(-1) in the SUMPRODUCT function. 4. The SIGN function is convenient to use together with the CHOOSE function (for three branching). 5. As far as I remember, the ISEVEN and ISODD functions were very slow. 6. I would end the topic of logical functions with Karnaugh maps and the Quine-McCluskey method. 7. Users often use the IF function in conditional formatting... 8. The logical operator/function AND corresponds to multiplication (*). The logical operator/function OR corresponds to addition (+, has the logic of several checkboxes, used by MsgBox in VBA as paramaters - icon and buttons for example).

@MyOnlineTrainingHub

4 ай бұрын

Thanks for watching and sharing!

Awesome video. Thanks Mynda 👍❤

@MyOnlineTrainingHub

9 ай бұрын

Thanks for watching! Glad you enjoyed it 😁

These are getting really good!

@MyOnlineTrainingHub

9 ай бұрын

Glad you like them! 🙏😁

A great fun video. Both informative and entertaining.

@MyOnlineTrainingHub

Ай бұрын

Glad you enjoyed it!

One word describes this video.. Brilliance. The perfect blend of everything with amazing information from start to finish...Brilliance.

@MyOnlineTrainingHub

4 ай бұрын

Wow, thank you so much! 🥰

Hi Mynda. Verry nice video again. I knew that all values above 1 are treated as TRUE, Mike Girvin explained this a few times. But I never, ever had seen the SIGN formula. Although there are workarounds, this function is now in my Excel "vocabulaire"....😊

@MyOnlineTrainingHub

9 ай бұрын

Awesome to hear, Bart!

Appreciate your very creative & humorous presentation!

@MyOnlineTrainingHub

9 ай бұрын

Thank you kindly! 🥰

You're my hero, Mynda.

@MyOnlineTrainingHub

9 ай бұрын

Thanks for your support 🥰

Hi Mynda, I LOVE your channel and your videos, and this one is no exception. Quick question: How do you get the actual formula to display on cell F17 at @3:38?

@MyOnlineTrainingHub

9 ай бұрын

Thanks so much, Guillermo! I used the FORMULATEXT function.

An excellent explanation on how Boolean affects the way we calculate in Excel, an advanced level video explained with funny examples. Thanks!!

@MyOnlineTrainingHub

6 ай бұрын

Glad you liked it 🙏😁

Thank you for this lesson.

@MyOnlineTrainingHub

8 ай бұрын

My pleasure 😊

Great video, thanks for sharing.

@MyOnlineTrainingHub

9 ай бұрын

Thank you and thanks for watching, Roy! 🙏

Confess that I often break down complex formulae into individual cell elements to see them working right, THEN copy the components into a single cell to build one final monster equation. These advanced tips on logic are gold, thanks! Especially how Boolean convert to numeric, had no idea. Also the Marvel Thor theme, nailed it. Thor is such a down to earth superhero/ demigod, he quickly adapted to earthly ways... But as the saying goes, he only has a hammer so treats every problem like a nail.

@MyOnlineTrainingHub

9 ай бұрын

😁 so pleased you learned some new tips and enjoyed the Thor theme! 🙏

I love this! I needed to laugh! Thank you!

@MyOnlineTrainingHub

9 ай бұрын

Glad you enjoyed it! 😁

Wow, super video! Will AND OR NOT invite THOR! No, but XOR would! By the way TH"OR" has "OR" in his name, but still! Loved this new way of edutainment! ❤ Thank you Mynda, keep those coming! 😊👍

@MyOnlineTrainingHub

9 ай бұрын

😁 Thanks, Vijay! Good point about TH"OR" 🤦‍♀️

Great presentation, tank you!

@MyOnlineTrainingHub

5 ай бұрын

Glad you liked it! 🙏😁

My favorite Excel tutorial video, Mynda Treacy deserves an Oscar, thank you. 🤩

@MyOnlineTrainingHub

8 ай бұрын

😂 so pleased you enjoyed it!

Great subject, well organized. As someone who is using quite a few IF and IFS, I didn't know these options existed. I need to rewatch a few times and use them on my own for the logic to stick. I like the straight no frills videos, but maybe the cut ins with Thor will make it more memorable, more so than a cookie company.

@MyOnlineTrainingHub

8 ай бұрын

😁thank you! Glad you found it helpful.

Thor’s having a tough time qualifying… Someone needs to check on him! Thanks for the video. I like to use the logical functions for readability but it’s good to know these pure logical tests are available to use too 😁

@MyOnlineTrainingHub

9 ай бұрын

😁 Great to hear, Darryl!

Hi Please make same type o log for all "forecast formulas" Thanks

Great Video .I have a question when I copy and paste into Excel, the page layout change why?

@MyOnlineTrainingHub

9 ай бұрын

I guess you're coping from somewhere that the format is different and you're pasting in the format as well as the data. Try paste special > values.

minute 8:34 = gem! 💎 amazing analogy Mynda! thanks!

@spilledgraphics

8 ай бұрын

I admit it, I was part of that group (minute 15:01) until couple of days ago.

@MyOnlineTrainingHub

8 ай бұрын

😁glad you enjoyed it 🙏

lol another great tutorial Mynda....fun too

@MyOnlineTrainingHub

9 ай бұрын

😊 thank you!

Your just awesome and I LOVE THOR!!!!!

@MyOnlineTrainingHub

9 ай бұрын

Thanks so much, John! 😆

Hillarious and enlightening

@MyOnlineTrainingHub

8 ай бұрын

😁thank you!

All the Marvel stuff really got in the way for me, especially when you consider that actors are on strike and you felt it appropriate to copy and paste their likenesses.

@MyOnlineTrainingHub

9 ай бұрын

Thanks for your comments, Andy. Hadn't thought about that given that all their past work is still being aired. Will give it some more thought though. Appreciate you taking the time to comment.

@andyloats383

9 ай бұрын

@@MyOnlineTrainingHub I wanted to reiterate though, one the main reasons for my comment is that I think you have the absolute best excel content available, anywhere and I really, really value what you’ve created. Having said that, I should also be conscious that you might want to explore and evolve. Anyway, Sorry I came across negative.

How do you write the formula with text on the side next to the result?

@MyOnlineTrainingHub

9 ай бұрын

I use the FORMULATEXT function 😉

what is the impact on memory when using one or the other formulas... as I have to deal with 135000 rows and 35 columns, memory/speed of calculations become a driver in which formulas I use (impact of conditional formatting is an example of the impact to memory/operation speed)

@MyOnlineTrainingHub

9 ай бұрын

I can imagine! After each section I mentioned which is going to be most efficient to use.

Amazing video

@MyOnlineTrainingHub

9 ай бұрын

Glad you think so! 🙏

Funny and educational. Nailed it !

@MyOnlineTrainingHub

9 ай бұрын

Thanks so much! 😁

Usefull and funny ! Thank you

@MyOnlineTrainingHub

9 ай бұрын

Glad you liked it, Claude!

You make me want to learn this.

@MyOnlineTrainingHub

4 ай бұрын

Awesome to hear 😁

Funny format! :-) In the beginning of the video, that biting of your finger was a bit telling… :-) Admittedly, we are a bit jealous, because we don’t want to share ‘our Mynda’, not even with Thor… ;-) PS: the logic functions are scalar valued, true, but we can always ‘vectorize’ everything in Excel nowadays, using BYROW, BYCOL, MAP,…

@MyOnlineTrainingHub

9 ай бұрын

Thanks Geert! Good point about vectorizing with the new dynamic array functions 🙏

You are funny and naughty in a very informative way 😂❤

@MyOnlineTrainingHub

9 ай бұрын

Thanks 😁

Those eyes at 1:21! 😀😀😀😀😀😀😀 Another great video, thanks!

@MyOnlineTrainingHub

9 ай бұрын

😁thanks for watching!

Mynda, as a HUGE Marvel fan, I loved this video 😂😂

@MyOnlineTrainingHub

9 ай бұрын

😁 great to hear, Chris!

Nice touch with Thor

@MyOnlineTrainingHub

9 ай бұрын

😁thanks so much!

OK. Must always include Thor. You two are perfect together.

@MyOnlineTrainingHub

9 ай бұрын

😁thank you!

How about SWITCH() function? It will do the same.

@MyOnlineTrainingHub

9 ай бұрын

No, SWITCH is more like CHOOSE in that it returns an item from a list.

@7absinth

9 ай бұрын

@@MyOnlineTrainingHub for example SWITCH(TRUE(), CRITERIA, OUTPUT, ELSE)

❤ for Excel from Sindh, Pakistan.

@MyOnlineTrainingHub

9 ай бұрын

Thank you for watching!

Great video as usual! but I'm looking forward to just plain excel video tutorial without all that junky extra stuff like Thor and the like! We excel addicted are tough and no frills guys!

@MyOnlineTrainingHub

9 ай бұрын

Coming soon! 😁

F9 for next step in 14:10 is excellent

@MyOnlineTrainingHub

9 ай бұрын

Glad you liked it 🙏

In university, I found logic as dry as unbuttered toast after a bowl of unbuttered, salty popcorn. Thankfully, this video is full of facts and way more fun than my university prof (alas, only a "C" in the course...). Anywho, quite delightful... thank you.

@MyOnlineTrainingHub

8 ай бұрын

😁wonderful to hear! 🙏

In USA companies still using ms Excel for their works ???

@MyOnlineTrainingHub

9 ай бұрын

In every country!

you have defen make excel videos more interesting for those who has to use excel, but never had the tension to learn , lol

@MyOnlineTrainingHub

9 ай бұрын

Awesome to hear 😁

He is right, extremely handsome a doesn't need Excel knowledge. awesome video. thanks

@MyOnlineTrainingHub

6 ай бұрын

😁Thanks for watching!

3:39 "all chests" - Mynda, I think you're confused by Thor's 'brains'. *wink*

@MyOnlineTrainingHub

9 ай бұрын

😂 probably!

99% seems like a very specific number. how was this statistic determined?

@MyOnlineTrainingHub

9 ай бұрын

Well, only 1% of Excel users use Tables, so I'm pretty confident at least as many don't know that in Excel positive and negative numbers = TRUE for many functions, conditional formatting etc. In fact, it's probably more than 99%, I was being conservative 😉

@abrahamtio

9 ай бұрын

@@MyOnlineTrainingHub 1% is also a very specific number. how do you know only 1% of excel users use tables?

💚

@MyOnlineTrainingHub

8 ай бұрын

🙏😁

The thor/marvel reference was entertaining at the start but became very distracting and cringe very quickly.

@MyOnlineTrainingHub

9 ай бұрын

Thanks for watching and the feedback 🙏

You made a mistake on the list of superheroes...you forgot to add your name.

@rudiklein

9 ай бұрын

Slick 😎

@MyOnlineTrainingHub

9 ай бұрын

@danknight 😁🙏

Excellers Assemble!

@MyOnlineTrainingHub

9 ай бұрын

😁

@tiger131071

9 ай бұрын

Very much enjoyed this video 😂 Great work @@MyOnlineTrainingHub

Logical operations make people's heads thor. Hah

@MyOnlineTrainingHub

9 ай бұрын

😂😂 very good!

Another approach would be to define your own AND function = ANDλ(A, B) where ANDλ = MAP(A, B, LAMBDA(x, y, AND(x, y)))

@MyOnlineTrainingHub

8 ай бұрын

Love it, Peter! Thanks for sharing 😊

Do you think Thor could come around to my house and explain Excel logic, say after 8pm? Any night he chooses! You're kinda being a bit mean to Thor, BTW!

@MyOnlineTrainingHub

Ай бұрын

🤣I think he's a bit busy at the moment promoting Furiosa, but maybe after.

👩‍🏫 this is 🍎 is for you 🫡 😎

@MyOnlineTrainingHub

9 ай бұрын

😂🙏😍

lol 😂

@MyOnlineTrainingHub

9 ай бұрын

😁thanks for watching!

😂

@MyOnlineTrainingHub

8 ай бұрын

Glad you enjoyed it!

Love it omg its so hilarious.. hahahahah these are all brainsssss omg

@MyOnlineTrainingHub

9 ай бұрын

😁 thanks for watching!