-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to hide #DIV/0!
- Thread starter petewann
- Start date
That's awesome, thank you so much
Upvote
0
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 63,880
- Office Version
- 365
- Platform
- Windows
That could possibly also hide other errors that you might want/need to know about.
Instead, assuming that any #DIV/0! error is resulting from D3 being zero or empty, you could directly address the division by 0 as follows. Again, an error message could be added between the double quotes if you want.
BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Instead, assuming that any #DIV/0! error is resulting from D3 being zero or empty, you could directly address the division by 0 as follows. Again, an error message could be added between the double quotes if you want.
Excel Formula:
=IF(D3=0,"",SUMPRODUCT(--(DATA!$F$5:$F$303=D$2),--(DATA!$BE$5:$BE$303=10))/D$3)BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Upvote
0
