What does absolute mean?

What does absolute mean in excel? What are absolute excels?

3 Answers

Relevance
  • DEBS
    Lv 7
    1 month ago
    Favourite answer

    An 'absolute reference' means that your formula will always refer to a specific cell no matter what.  

    Relative Reference in C1:  =A1+B1

        If you were to copy cell C1 to C2, C2's formula would say A2+B2

        If you were to copy cell C1 to H19, H19's formula would say F19+G19

    Absolute Reference in C1:  $A$1+$B$1

        No matter where you copy C1 to, that cell will always refer to $A$1+$B$1.

    Absolute Reference in C1:  $A1+B$1

       Copy C1 to H19, H19's formula will be $A19+H$1   (The $ holds the column and/or the row so that it never moves.)

    • Blue nose
      Lv 4
      1 month agoReport

      Thanks DEBS that's very thorough!

    • Commenter avatarLog in to reply to the answers
  • L.N.
    Lv 7
    1 month ago

    An absolute is a real number magnitude without regard for sign. 

    • Commenter avatarLog in to reply to the answers
  • 1 month ago

    Absolute means an integer with no sign. abs(-5) = 5

    • Commenter avatarLog in to reply to the answers
Still have questions? Get answers by asking now.