gonefishing
New Member
- Joined
- Mar 5, 2013
- Messages
- 1
I am a long time reader, first time poster.
I am trying to solve for how much months of supply for a product a retailer
but also want it to be broken down by either the first or second decimal so if
its less than 1 it it will say .77 (3 weeks of supply; now it displays 0. I
would greatly appreicate the help. Thank you for your time. Cheers.
Legend: BN5=retailer ending inventory W5=point of sale (POS) and W5+X5+Y5+Z5
are all point of sale monthly data points. A quick example In March you start
with 12 units and in March your POS is 3 so you would have 4 months of
inventory.
=IF(BN5>=W5,IF(BN5>=W5+X5,IF(BN5>=W5+X5+Y5,IF(BN5>=W5+X5+Y5+Z5,IF(BN5>=W5+X5+Y5+Z5+AA5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5+AD5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5+AD5+AE5,9,8),7),6),5),4),3),2),1),0)
I am trying to solve for how much months of supply for a product a retailer
but also want it to be broken down by either the first or second decimal so if
its less than 1 it it will say .77 (3 weeks of supply; now it displays 0. I
would greatly appreicate the help. Thank you for your time. Cheers.
Legend: BN5=retailer ending inventory W5=point of sale (POS) and W5+X5+Y5+Z5
are all point of sale monthly data points. A quick example In March you start
with 12 units and in March your POS is 3 so you would have 4 months of
inventory.
=IF(BN5>=W5,IF(BN5>=W5+X5,IF(BN5>=W5+X5+Y5,IF(BN5>=W5+X5+Y5+Z5,IF(BN5>=W5+X5+Y5+Z5+AA5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5+AD5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5+AD5+AE5,9,8),7),6),5),4),3),2),1),0)