#DIV/0! Error

[ash_j98]

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 storage bin. I know there can't be 89 years worth of inventory in there...what am I doing wrong? 

formulas used to calculate columns:

Pieces=usage/work day avg

replen frequency days=new max/pieces

replen frequency mos= replen frequency days/30.417

replen frequency yrs=replen frequency mos/12

[#2]

@ash_j98 

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?

[#3]

Reworking usage helped a bit. Do you think anything else could be wrong as far as the math goes in the dark blue columns?

[#4 · Accepted solution]

@ash_j98 

The formulas are OK, I suspect the input values are off.