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.
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.