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 |
I have a column of 50 numbers
Skip wrote:
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 =A1+SIGN(A1) |
All times are GMT +1. The time now is 06:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com