cell reference another sheet but reverse the sign

[CMDorsey]

I need to reference a cell in another sheet - in sheet 2 cell A4 has a value of -25, in sheet 1 A4 I want the value from sheet 2, cell A4 but as a positive 25, any suggestions?

 

[SkipVought]

Hi,

Use the ABS() function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Sorry, to REVERSE the sign ie 1 to + ot + to 1, multiply the reference by -1.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[randy700]

Or, multiply by -1.

Randy

 

[mintjulep]

Or just stick a - in front.

=-Sheet2!A4