Formula in excel to change - to +

[mrbalaje]

What is the formula to indicate the negative values as positive value.

For example: How to display -32 as 32 in a cell.

Note: If the cell already has positive value (32), then retain the same.

 

[Raj]

The formulae would be

=if(A1<0,A1*-1,A1)

I hope the same works.

Regards
Raj

 

[MartinW]

Hi mrbalaje,

Try =ABS(A1)

HTH
Martin