So to convert them into positive you just need to enter the formula in cell B2 and drag it up to the last cell. ![]() ![]() So you can use the same method in excel to convert a negative number into a positive.Īll you have to do just multiply a negative value with -1 and it will return the positive number instead of the negative.īelow you have a range of cells with negative numbers. Unlike me, if you are good at maths, I am sure you know that when you multiply two minus signs with each other, the result is always positive. Multiply with Minus One to Convert a Positive Number So today in this post, I’d like to share all those methods with you. So this time I grabbed a paper and listed all the methods which I can use to convert a negative number into a positive. But have you ever checked how my different methods you have to do this? Well, I am always curious to know about different methods to do a task in Excel. I am sure, this often happens with you, when you get some negative numeric values, and after that, you convert them into positive. You know, the thing for which he asked is a common kind of task. Hey Puneet, how many methods we have to convert a negative number into a positive one? ![]() Last week, I got an email from one of my subscribers with a question. And you will be amazed that I have got 7 different ways which you can use to deal with negative numbers.
0 Comments
Leave a Reply. |