Linked Spreadsheet

[swan717]

Hi:

I am trying to figure out how to change a negative linked number to a positive number, without having to manual change it.

Can anyone help?

Thanks

 

[xlbo]

If you have a basic cell link (ie =sheet1!A1 etc), just change the formula to =A1*-1
or, if the nuimber may not always be -ve, =if(sheet1!A1<0,sheet1!A1*-1,sheet1!A1)
Rgds
~Geoff~

 

[beniez]

Or, simpler still if you want to invert the number whether positive or negative (which is what you usually want to do), try =-A1

HTH

Ben