RIGHT HAND OPERATIONS
  • Home
  • About Us
  • Services
  • Contact
  • Blog
  • Why Use RHO?

The RHO BLOG

Helpful tips and news from Right Hand Operations.

Do you use IFERROR?

10/18/2017

0 Comments

 
For my friends who use Excel for reporting, are you using the IFERROR function? If not, I highly recommend it. If you do reporting as part of your job function, you may avoid populating formula cells for future dates because you don't want to display any of the errors Excel gives you when data is missing, such as the "DIV/0!" error.

Blanking those cells out works, yes, but using the IFERROR function allows you to still populate your formulas in advance and display a blank value (or any other value you so choose) if an error exists.

For those of you who live by Excel, I don't have to tell you how much fun this formula is to use! 
This is an example displaying the errors:
Picture

This is an example using the IFERROR function to get rid of the error display

Picture
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Picture

    Author

    I'm Lindsey Crabtree, the Founder and CEO of Right Hand Operations. I love meeting new people and making connections, I love observing the commonalities between our clients and how we all have similar struggles in the business world. As I have time I enjoy reflecting on experiences and sharing what I've learned. 

    Archives

    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    August 2018
    June 2018
    May 2018
    March 2018
    February 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    June 2017
    May 2017

    Categories

    All

    RSS Feed

Picture
Picture
Picture

Hours

M-F: 8am - 5pm

Telephone

859-300-3321

Email

info@righthandoperations.com
Address
1795 Alysheba Way, Suite 6202, Lexington, KY 40509
  • Home
  • About Us
  • Services
  • Contact
  • Blog
  • Why Use RHO?