View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackie Jackie is offline
external usenet poster
 
Posts: 78
Default tracking inventory

if there's a # in the "Qty. Received" cell then I want it to add to the
"Current inventory" cell but if there's a # in the "Qty. Shipped" cell then I
want it to subtract it........how can i seperate these functions in 1 formula
so it will do either 1 or the other?