If the current inventory amount is in A1 try this formula

=MAX(0,7-A1)

"Belinda" wrote:

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???