Per exemple, si la cel· la A1 us ha indicat el nom fred aleshores podreu introduir una fórmula com =' fred '+ 2 dintre d' una altra cel· la que sempre donaria com a resultat d' afegir 2 al valor en A1, sense importar a on es copiï la cel· la de fórmula.
For example, if cell A1 has been given the name fred then you can enter a formula such as ='fred '+ 2 into another cell which would always give the result of adding 2 to the value in A1 no matter where the formula cell was copied to.