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

Cumulative formula for word table 0
Reference 2 3
How do I create the formula for this calculation? 1
Conversion of Array Elements to PerCent 2
Excel Sort 4
time sheet and majority hours 4
List of dates 7
Copying parts of a sheet with macro 7

Top