Eric P. Butts

THE Career Site for Accountants and Consultants.

  • Home
  • About
  • Useful Resources
  • Articles
  • Work With Me
    • Breakthrough Resume Writing
    • How to Get Smart in Excel…Fast!
    • Corporate Ladder University (Book)
  • Login
You are here: Home / Excel / How to get more out of OR in Excel

January 21, 2017 by Eric Butts Leave a Comment

How to get more out of OR in Excel

 

I don’t always like to use helper columns but when I do, the OR function comes in handy. There are a couple of scenarios where I find this useful. First, if there is a column containing a list of values that is too detailed for the information you want to present, you may want to group them. For example, if you’re dealing with a data set of cars and car color is a column and you see values such as Blue, Dark Blue, Light Blue, Turquoise, you may want to summarize them all as “Blue” or “Shades of Blue” for an executive summary type of view.

Another example would be having a data set where a combination of fields represent the grouping of information you’re most interested in. Let’s say you had a potential set of dating candidates where you had age, income, and undergraduate school available to you. And maybe you have a few deal breakers. For the sake of discussion, I’m going to assume you don’t want to date married people or people older than 45 years old. You may want a field that addresses both of these things at the same time.

The syntax of the OR function is simple: =OR(criteria1, criteria2,…). If you use the function alone, you will get an output of True if one of the criteria is satisfied and false otherwise. To perform either of the two items above, you need to combine the OR function with the IF function, and you want to make sure you use quotation marks where necessary so that Excel will interpret your command correctly. Otherwise, your formula may return a false error. I talk about that in more detail in the video (click below to sign up to have it emailed to you for FREE).

Click Here to Have the Video Sent to You

Filed Under: Excel Tagged With: conditional formulas, embedded formulas, excel formulas

About Eric Butts

I’m a management consultant, MBA and CPA who has a passion for helping others in their career pursuits. Grab my FREE cheatsheet on 12 simple habits of highly successful consultants.

Leave a Reply Cancel reply

You must be logged in to post a comment.

Featured Posts

The Most Effective Way To Network So Everyone Knows Your Name

Motivating Employees: Take The Time to Meet Your People

Why Consultants Hate Their Clients But Keep Coming Back For More

How to Get Into Business School – Part 4 (Recommendations)

What’s So Bad About Applying to a Job More Than Once?

Popular Posts

  • 5 Reasons You Should Be Proud to Ask Dumb Questions at Work
  • What Does It Mean to Have a Sense of Urgency
  • Always Stay Close to the Gatekeepers
  • Why Are There Still So Few Black CPAs?
  • What's the Difference Between FP&A and Accounting?
  • 3 Reasons Average Students Become Good Accountants
  • One Thing You Should Never Do on Linkedin
  • How to Handle Double Standards in the Workplace
  • How to Pass the CPA Exam Without Breaking the Bank
  • Masters in Accounting Isn't The Sweet Treat Some Students Think

Recent Posts

  • The 3 word Facebook post that has me feeling all kinds of motivated right now
  • I think I discovered the last fax machine this weekend (and a related lesson you should be immediately applying)
  • How to create your own luck in your career
  • Here’s why you may want to rethink that skills section on your resume
  • Internet troll triggered by a pair of tweets
  • Privacy Policy
  • Terms of Use
  • Disclaimer

© 2012–2021 Eric P. Butts