Reference

J

Jackie Morin

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.
 
J

Jackie Morin

Jackie Morin said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference 2 3
How do I create the formula for this calculation? 1
Conversion of Array Elements to PerCent 2
time sheet and majority hours 8
Excel 2003 - Tracking caps 4
Selcting data from table without repeating plus calc's 2
Excel 2002 Pivot Table: Can I customize formulas ? 3
Update Stock Inventory 2

Top