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!
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
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
Thanks again, figured out how to use an AND inside of an IF statement on my own, saved me so much time.
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.
How does the input/variable affect related cell 1 and related cell 2?
Oh wait I got it : ).
Pingback: A Complete Introduction to Excel | MBAx.me
Great work, showing/viewing is THE way to learn
May our Almighty God bless you more for this good deed.. It really helps a lot of people.
Thanks, This is helpful!
Thanks alot, this really helps!!
Website is looking good. Thanks for doing this!