Please see attached example
I realize that this is probably simple fix but for some reason it's giving me trouble. I don't have any issue with #DIV/0! showing up in the Data sheet, but I need to know how to go about having it not appear on the Scorecard sheet. Not only does it look bad but it hinders the Year to Date Average from automatically tallying up each month. Any help would be most appreciated. Thank you!
using your posted workbook....
Data sheet
Copy that formula down through F31
Please Login or Register to view this content.
On the Scorecard sheet.
Use this regular formula, copied across to the right
Is that something you can work with?Please Login or Register to view this content.
I would suggest to use NA()
=IFERROR(SUM(D8/E8)*1000,NA())
This way your chart will look nicer. Also, use Conditional Formatting to hide errors
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Yes sir, that works great. Instead of "n/a" I just used "" and it not only made everything blank but it seemed to automatically fix the issue on the Scorecard sheet as well. Thank you again, this forum can be a lifesaver when Excel headaches arise.
Very cool, thank you again!Originally Posted by AlKey
You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks