B
Belinda
e.g., my inventory qty should always be 7. if inventory is at 3, i want a
formula to put a 4 in the order column. how do i do that???
formula to put a 4 in the order column. how do i do that???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
daddylonglegs
If the current inventory amount is in A1 try this formula
=MAX(0,7-A1)
=MAX(0,7-A1)
D
Dave Thomas
Inventory quantity is in A1. Order cell is in B1. In B1 put
=IF(A1<7,7-A1,0). This shows 0 in the order cell if you do not need to order
anything.
If you want nothing to show instead of 0 put =IF(A1<7,7-A1,"")
=IF(A1<7,7-A1,0). This shows 0 in the order cell if you do not need to order
anything.
If you want nothing to show instead of 0 put =IF(A1<7,7-A1,"")
B
Belinda
i'll be doggone if that didn't work! THANKS a bunch.
B
Belinda
that worked too!! THANKS Dave.
Dave Thomas said:Inventory quantity is in A1. Order cell is in B1. In B1 put
=IF(A1<7,7-A1,0). This shows 0 in the order cell if you do not need to order
anything.
If you want nothing to show instead of 0 put =IF(A1<7,7-A1,"")