Formula in excel to change - to +
 

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.

Formula in excel to change - to +
 

The formulae would be

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

I hope the same works.

Regards
Raj

"mrbalaje" wrote:

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.

Formula in excel to change - to +
 

Hi mrbalaje,

Try =ABS(A1)

HTH
Martin