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: This is an example using the IFERROR function to get rid of the error display
0 Comments
Your comment will be posted after it is approved.
Leave a Reply. |
AuthorI'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
Categories |