ExcelBanter - Absolute refferences

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Absolute refferences (https://www.excelbanter.com/excel-discussion-misc-queries/182107-absolute-refferences.html)

Sharon

Absolute refferences

Hi I am trying to find the right formula to change to an absolute number, I
have two numbers to use to change it? Lost again in excel can anyone help.
Thank you

Tyro[_2_]

Absolute refferences

If the number is in A1, then =ABS(A1)

Tyro

"Sharon" wrote in message
...
Hi I am trying to find the right formula to change to an absolute number,
I
have two numbers to use to change it? Lost again in excel can anyone help.
Thank you

Mike

Absolute refferences

=ABS(A1) 'Put this in B1

"Sharon" wrote:

Hi I am trying to find the right formula to change to an absolute number, I
have two numbers to use to change it? Lost again in excel can anyone help.
Thank you

All times are GMT +1. The time now is 10:43 PM.