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,"")

"Belinda" wrote in message
...
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???