Forum Discussion
Solved
#DIV/0! Error
Hey! first post here..trying not to get frustrated over this but my data isn't turning out how I want it to. I want the dark blue columns to read as days, mos, and years worth of inventory in a stora...
The formulas are OK, I suspect the input values are off.
In the first data row, usage is only 0.2 per month.
With a new max of 270, that is enough for 270/0.2 = 1350 months. That is over 100 years.
Perhaps the average of 0.2/month is not realistic?
Reworking usage helped a bit. Do you think anything else could be wrong as far as the math goes in the dark blue columns?
The formulas are OK, I suspect the input values are off.