Very Simple Formula Error!

**an Engineer** · 07-01-2015, 11:49 AM

Hello Community,

I have a document which has two similar pages. The information at the top of both sheets is the same.
Obviously, to do this, I click in the cell on the second sheet, type "=", navigate my way to the cell which has the information in it (on the first sheet), then hit enter.

this works for 99% of the sheet except two cells. The two cells return "#VALUE!" when I hit enter.

Any ideas why?

This is really frustrating because it's such a simple formula. There must be some hidden characters in there or something.

Regards,
James

**FDibbins** · 07-01-2015, 11:59 AM

What is in those other cells?

**bigroo1958** · 07-01-2015, 12:06 PM

an Engineer,

I would check those two cells which are showing the error and make sure you have no blank characters before or after the formula.
Also, check the format of the cell as well.
Also, check you have the right character in those cells as well, number instead of text or whatever should be in the cell.

Other than that, without seen an example, not too sure.

Thanks