promotion image of download ymail app
Promoted

What does absolute mean?

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

3 Answers

Relevance
  • DEBS
    Lv 7
    2 months ago
    Favorite 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
      2 months agoReport

      Thanks DEBS that's very thorough!

    • Commenter avatarLogin to reply the answers
  • L.N.
    Lv 7
    2 months ago

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

    • Commenter avatarLogin to reply the answers
  • 2 months ago

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

    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.