View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Negative values in a formula

Do you mean that when you add the numbers you want to treat the negative
numbers as zero, or that you want to treat them as positive (and take the
absolute value)?
--
David Biddulph

"Susan" wrote in message
...
How do you enter a formula to add the value of cells in a column, but
minus
negative values in the column?

Susan