Some time ago, I created a custom function to calculated the number of days sales that can be covered by the current inventory balance (commonly known as Days on Hand). The function essentially figures out how many months of demand the inventory can cover and then multiplies this by an array of days in each month. During testing, the formula worked fine and there were no errors - there also were no errors when other groups started using it.
Now, one user is putting the function into a massive file with many other calculations included. Occassionally, the DOH function returns a #Name error. Unfortunately, it seems to occur haphazzardly - i.e. it will error out with a calculation, we can try to calculate, resave, etc to no avail, and then all of a sudden it will work for no reason. I was wondering if anyone had run into anything like this. The function has been a huge time saver, but obviously is of little use if it isn't reliable. TIA - Chad
Bookmarks