When creating a formula, how do you change a selected cell to an absolute value?
R Richard Stedman Mar 12, 2009 #1 When creating a formula, how do you change a selected cell to an absolute value?
L Luke M Mar 12, 2009 #2 Absolute value (-2 becomes 2) =ABS(A2) Absolute reference (column) =$A2 Absolute reference (row) =A$2
Absolute value (-2 becomes 2) =ABS(A2) Absolute reference (column) =$A2 Absolute reference (row) =A$2
