Video Lesson: Logical Functions and Formulas

This Excel video lesson is about Logical Functions and Formulas in Excel.  Here are the formulas that I go through in the video lesson:

Logical formulas are extremely useful in more advanced Excel spreadsheets/methods and they are a great tool to have at your disposal.

Make sure to download the most recent Master Excel Workbook so that you can follow along. The spreadsheet I’m reviewing is in the Function Examples sheet in that Excel file.

The formulas covered in this video lesson are:

IF – IFERROR – AND – OR – TRUE – FALSE – NOT

Thanks for watching and feel free to leave any questions or comments in the comment box below!

24 thoughts on “Video Lesson: Logical Functions and Formulas

  1. Hi!

    Love your lessons! The explanation is easy to understand.
    Can you please suggest the next chapter after this one?

    Thank you Ben!
    You rock!

  2. Oooh I can only say God Bless You mightily for this. I am a long time user of Excel, I use it for my work as a financial analyst and I have learnt things that i did not even know that I needed to know. My confidence level using Excel has skyrocketed!!
    Do you have similar training for MS Word, Powerpoint and Access

    Thank you sooo much

  3. We’re ɑ gaggle of volunteers аnd opening ɑ new scheme
    іn oսr community. Your website provided us with useful infօrmation to աork on. You Һave performed аn impressive activity аnd our entire neighborhood ѡill ρrobably bе thankful tߋ yߋu.

  4. Hi,
    I haven’t been able to watch a single video on your site. 😦
    There’s a blank space where the video should appear.
    I’m using Windows 8. Tried IE and Chrome, nothing works !
    I really need this course !
    Please help ?

  5. Thanks for the lesson. Would you mind to clarify the use of true or false? It is hard for me to imagine any application …

    • Computers at their most basic operating capabilities use a language called binaries. This is a language of 1’s and 0’s that respectively mean “on” and “off”. Look at all of the things that we are able to make computers accomplish with a language that can be considered strikingly similar to “true and false”. It is possible to create complex worksheets in excel that rival multi-million dollar programs that massive corporations purchase. Everything I have been able to logically think through, I have been able to accomplish in excel. The key is to have a determined outcome. Know what you want to happen, and using the tools you can find here, work out how you will get from point A to point B.

  6. Woo! I’m just writing to tell you that I’ve been following along with the lessons for the past day or two, and I already used something I learned at work today! Thanks a lot, Ben!

    For ayone else who reads this: I’m 18 and 100% new to anything Excel related (outside of basic formatting). I had no prior experience with formulas at all. And I’ve been watching the videos for about two days now.

  7. Your videos have been most helpful and I really appreciate what you’ve put together here.
    While I know that Excel is a very powerful application, I find it difficult to develop Excel skills in a vacuum — that is difficult unless a pressing and current need presents itself. I do hotel accounting and I remember having a vexing problem at work that inspired me to hone my skills on arrays. And I was able to rise to the challenge. Recently, I lost what might have been an exciting opportunity because -while I knew what they were — I lacked experience with VLookups and Pivot Tables. And I do really like Excel. Perhaps it’s just me personally, but the incentive to develop skills this way just doesn’t seem strong enough until a specific need presents. So being proactive that way seems hard. Just wanted to say that. Thanks for listening.

    Donald

  8. Thanks for this. I’ve watched all videos up to this one and they have been great. I guess my skills, however, are more basic than your average basic user as I wasn’t familiar with the HLookup fucntion, which was used in this video example and workbook. Is there another area on your site that you can guide me to that will explain these apparently basic functions?

    Cheers,

    Paul

  9. One question on an “if/then” formula. I have a spreadsheet, one column has product code/container size, for example ZB1300-1D for 55 gal. drums or ZB1300-5G for 5 gal. pails, there are also a variety of other container sizes. How would I create an if it is 1D divide amount by 55, if it is 5G divide by 5, if it is BD, divid by 275 and so on? is it possible to do if the column includes both text and nos. I’m stumped!!

    • Hi,
      If you have a look at the text functions video you should be able to figure out the first step – splitting off the last two characters that ID the container size, then use IF’s to give you your division – you can nest them like this whereby the ‘value if false’ will be to test another IF statement: =IF(E92=”1D”, 55, IF(E92=”5G”, 5, IF(E92=”BD”,275)))

      The use that returned value / cell reference to divide your original number.

      Not sure if that’s the most elegant way, particularly if you have lots of container sizes when the nesting gets complex, but it should work.

  10. Pingback: A Complete Introduction to Excel | MBAx.me

Post any comments, feedback or questions below!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s