I have a column of 50 numbers

Skip · External Since: Nov 03, 2009 Posts: 1

some are negative, some are positve. I need to add +2 to the positive
numbers, and -2 to the negative numbers. So 4 becomes 6 and -10
becomes -12. I received help for +1/-1 last week, but now I need
+2/-2. Thanks

David Biddulph · External Since: Feb 24, 2007 Posts: 1286

See the answer to your previous thread.
--
David Biddulph

"Skip" <ssummer.RemoveThis@live.com> wrote in message
news:b92f4620-74a1-4d0a-b516-e200d4fc13bf@p35g2000yqh.googlegroups.com...
> some are negative, some are positve. I need to add +2 to the positive
> numbers, and -2 to the negative numbers. So 4 becomes 6 and -10
> becomes -12. I received help for +1/-1 last week, but now I need
> +2/-2. Thanks