Uncomplicate Your Nested IF Statements with the New IFS Function

If you’ve ever had to write a nested IF function in Excel, you know how complicated they can get. You might get to the end, nervously hit Enter, and see that the whole thing has failed because you forgot a few parentheses, or you missed a comma. Well, if you have Office 365 or Office 2019, you now have access to a ridiculously easy way to create nested IF statements. It’s called the IFS function. 

Excel doesn’t often debut new functions, but boy is this one a gamechanger. Just liked a nested IF, it tests if various conditions are true, and then returns a value accordingly. Here’s the syntax of the IFS function:

=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)

You can test up to 127 conditions. That’s right, 127! But it’s always best practice not to have too many conditions, as it can be difficult to test and modify something that long. But hey, if you are so inclined, go for it.

The easiest way to learn how to use IFS function? Watch our video and see it in action:

You can find many more videos on the new features of Office 365 and Office 2019 at www.intellezy.com.

By Heather Walsh


I was raised believing that to be able to live a truly full life you need to find a career you love that will allow you a way to always be giving back. I have absolutely found that career at Intellezy and I have been creating space in my life to give back in different ways since I was a teenager. I am always struck in job interviews and on the job encounters when someone finds out things that I have done; it inevitably opens up a new conversation and creates a different kind of positive relationship. Using the knack I have for organizing, team building, and social gathering has allowed me to do more than my 9-5 by giving back in ways that utilize my skills.

I love to organize and keep a team of workers moving in a positive direction. I also love basketball. I am not very good at playing it, but I love to watch it and understand the basics. So, when I was approached to be an Assistant Coach for a Special Olympics basketball program, I jumped at the chance!  What a way to combine everything I love. Later, when the kids were little and coaching was tough to add to the schedule, I decided to form a team for a 3-day fundraiser walk as a way to get back in shape and still be part of something.  I organized training walks and fundraisers and team events, and we raised a ton of money and completed 60 miles of walking as a team! These days, between working and running around for the kids, I am pressed for time and discretionary funds so I found an organization close to my heart that is moving into my area and needs to start building brand awareness and reaching out.  I am thrilled to be able to use my social media and speaking skills to help them.

So, think about the skills you have outside of just the ones you use daily at your job.  How can you use these skills to help others?  Make of list of what you’re good at, from cooking to accounting and everything in between.  Next, make a list of things you care about and want to help with, local to globally, then offer your gifts as a way to make the world a better place!

We all work really hard and between our families and commitments there is often little time for anything else, but if we can find a way to use the skills that bring in our paychecks to benefit others, we can grow our resumes and fill our hearts!

Coach headed off to the Special Olympics dance with some of my favorite North Shore Jazz players!

Be brave, be awesome and smile whenever possible.
Kristen Teixeira

*Got the basics down?  Awesome!  Try our intermediate and advanced courses and keep building your skills so you can help others!

Sorting Deleted Items by Date Deleted, Not Date Received

by Pam Conway, CLO and VP of Operations @ Intellezy

Recently, while working in my home office, my cat, Edgar, hopped up on my desk and promptly parked himself on my keyboard. Before I could dislodge him, his furry behind managed to delete a huge swath of messages in my Outlook Inbox. These weren’t all new messages, I quickly realized. Many were a few weeks old, left in my inbox as reminders to follow up. When I hurried over to my Deleted Items folder and remembered that it lists all messages in the order they were received, not the order in which they were deleted, I understood the magnitude of Edgar’s actions. I would need to recall the exact subject lines of each message deleted and then scroll through the deleted items folder in the hopes of finding them further back in the chronology. The problem? I couldn’t recall the specifics of a single message, only that I was missing at least a dozen or more.

What to do?! Well, luckily, I remembered my ability to customize the field headings in any folder and I was able to add a column that allowed me to sort the contents of my deleted items folder by when it was modified, which equated to the date it was deleted. Here’s how I did it:

1. In the deleted items folder, click the View tab and then click View Settings.

2. Next, click the Columns button.

3. Click the dropdown arrow for the Select available columns from list.

4. Select Date/Time fields.

5. Select Modified from the list and then click the Add button. The Modified column heading will be added to the list of column headings on the left. It will appear in the last position, which equates to the far right of the list of columns in the folder.

6. Use the Move Up button if you want the Modified column to appear in a different location.

7. Click OK in each of the two dialog boxes to return to the deleted items folder.

8. You will now see a Modified column header. Click the header to sort by this field. All recently deleted messages will now appear at the top of your deleted items!