3 columns for inventory control

[mikeaaalaser]

Hi guys,

I have 3 columns in this order: "Qty in stock at all times" (which is our set goal to have), "Qty actually in stock", and "Qty needed."

I want to have the 3rd column (Qty needed) to automatically adjust when I put in figures of what's actually in stock. So basically, if I want 1 in stock for everything, have it calculate to tell me I need 1 of certain types.

Thanks,

Mike

[Tank997]

Try this in C2
=if(B2<A2,A2-B2,0)

[mikeaaalaser]

Wow, that's perfect. Thanks Tank. That would have took me years.