View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Skip[_2_] Skip[_2_] is offline
external usenet poster
 
Posts: 29
Default I have a column of 50 numbers

some are negative and some are positive. I need to add +1 to the
positive numbers and -1 to the negative numbers.
So 4 becomes 5 and -10 becomes -11. Am I stuck in doing this
manually? Thanks for any help. Skip