absolute and relative cell referncing

the difference between absolute and relative cell referencing

?

Absolute cell referencing

  • used when data needs to remain the same when formulas and functions are copied to other cells
  • if the value changes it only has to be changed once
  • uses dollar sign ($) in the formula to make it absolute
1 of 2

relative cell referencing

  • data in the cell changes when the formula is copied
  • when the formula or function is copied to other cells, the cell reference within the formula or function will move
2 of 2

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »