Thread: Absolute
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default 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?
Reply With QuoteReply With Quote