Rigo wrote:
It means a cell to which the formula makes reference, has been
moved, deleted etc. and no longer supplies the data the formula
needs.
Click on your help wizzard and type #REF! to read more.

Regards.

-----------------------------
"Jazzy1980" escribió en el mensaje
...

What does #REF! mean and how do I change it.


----------------------------------

And following up on Rigo's comment, I most frequently see that when I
have some nicely working formula which references cell A1 for example.

If I then CUT and paste something over top of A1 it seems to confuse the
formula and it loses its reference to A1 and gives the #REF! error. On
the other hand if I COPY and paste then it doesn't confuse the formula.

Good luck...

Bill