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 (click below for larger image):

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!  I will respond via email if you include it with your comment.

This entry was posted in Function-Related Lessons and tagged , , , , , , , . Bookmark the permalink.

28 Responses to Video Lesson: Logical Functions and Formulas

1. a says:

2. Edmund says:

Hi,

For the IF logic function, can I apply this to an entire column of data?
For example:
If I can’t do that, how can I do it without manually typing the argument using the AND function i.e. =AND(A1=10,A2=10,A3=10,…) ?

Hope you can help. Thanks.

Edmund

3. Tirtha Chhetri says:

Hi, thank you very much for your excellent and easy steps that you have guided. It is easy to understand. Just one comments that it is little bit small view to see.

4. Anonymous says:

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!

5. YLS says:

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

6. Are there any free training coursess regarding MS Word, Powerpoint , OneNote or Access?

7. Anonymous says:

This guy is GOD

8. gary says:

you lost me with the hlookup table
I couldn’t duplicate what you did

9. advanced online drum lessons says:

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.

10. Anonymous says:

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 !

11. Anonymous says:

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

• Anonymous says:

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.

12. Naresh says:

website is very educative- it is very useful in day to day professional life to make the job interesting..

13. Jamie @ Trackhound Indie Music Blog says:

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.

14. Donald says:

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

15. Paul says:

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

16. danny says:

Thanks again, figured out how to use an AND inside of an IF statement on my own, saved me so much time.

17. Marge Koons says:

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!!

• Hullaballoo says:

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.

18. Colby says:

How does the input/variable affect related cell 1 and related cell 2?

• Colby says:

Oh wait I got it : ).

19. Johan says:

Great work, showing/viewing is THE way to learn

20. Anonymous says:

May our Almighty God bless you more for this good deed.. It really helps a lot of people.

21. Anonymous says: