Excel wizz help needed....
I have a report that I run that basically looks at shares... except, where it's trying to take a share of "0", you inevitably get the whole "DIV/0!" issue.
The report that people read therefore pulls through the "DIV/0!" value. Now, no-one's complained, but for aesthetics reasons, I'd really like to get rid of that, so I've tried building an IF clause:
=IF(PromoData!Y17="DIV/0!",0,PromoData!Y17)
except - it's still pulling through the "DIV/0!" and I have tried everything I can think of, putting " " instead of the 0, putting just "", leaving it blank altogether etc. etc. but nothing seems to be working...
Any Excel wizzes out there who can tell me where I'm going wrong?
Thanks y'all!
EDIT: Thanks to a colleague, I have now learnt all about the ISERROR function. Whoop.
Comments