Thread: number < 0 = 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yaypalmtrees
 
Posts: n/a
Default number < 0 = 0

I am trying to conduct inventory of hardware. I need to know based on what i
have, what i need to order. When i place the needed qty, and subtract the
instock qty, sometimes i receive a neg. number. What formula do i use, so
that instead of a neg. number, it automatically shows up as a "0"?