How do I have a cell look to another cell and formulate a number based on
inventory levels? For example:

Column A = 1800
Column B = 100
If column B is less than A how many lots of 1800 it would take to replenish
to level back above the 1800. In this calculation I would need (1) lot of
1800. My balance would be 18100. Now if I were negative 600 for column A it
would take (2) lots of 1800 to replenish my stock.

"Jackie Morin" wrote:

How do I have a cell look to another cell and formulate a number based on
inventory levels? For example:

Column A = 1800
Column B = 100
If column B is less than A how many lots of 1800 it would take to replenish
level back above the 1800. In this calculation I would need (1) lot of
1800. My balance would be 1900. Now if I were negative 600 for column A it
would take (2) lots of 1800 to replenish my stock.

=if(b1<a1,int(a1-ba/a1)+1,0)

Jackie Morin wrote:

How do I have a cell look to another cell and formulate a number based on
inventory levels? For example:

Column A = 1800
Column B = 100
If column B is less than A how many lots of 1800 it would take to replenish
to level back above the 1800. In this calculation I would need (1) lot of
1800. My balance would be 18100. Now if I were negative 600 for column A it
would take (2) lots of 1800 to replenish my stock.

Excel 2007
Optimize inventory levels
http://c0444202.cdn.cloudfiles.racks...12_15_09a.xlsm