ExcelBanter - Absolute

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

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

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

Richard Stedman[_2_]

Absolute

When creating a formula, how do you change a selected cell to an absolute
value?

Luke M

Absolute

Absolute value (-2 becomes 2)
=ABS(A2)
Absolute reference (column)
=$A2
Absolute reference (row)
=A$2
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Richard Stedman" wrote:

When creating a formula, how do you change a selected cell to an absolute
value?

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