Question

what is the formula in ms Excel for negative Vue change into positive values?
a)=power
b)=max
c)=abs
d)=trim



give confirm answer plz ,if you don't no then don't answer plz ​

Answer 1

Answer:

Solution: Using the absolute function 'abs', create another column that is adjacent to the column you want to make positive. For example if cell A1 is negative, on cell B1 you will use '=abs(A1)', and drag this down to be the same height as column A1's negative numbers.