1. Computing
#REF! - Invalid Cell Reference Errors
#REF! - Invalid Cell Reference Errors
© Ted French
A third common error value that appears in Excel spreadsheets is #REF!. This error appears when there is a problem with a formula or function.

The problem occurs when cell references or ranges in a formula are incorrect.

Similar to #NULL! errors, #REF! errors usually occur if changes have been made to a spreadsheet.

For more information on this error message, read the article on #REF! - Invalid Cell Reference Errors .

Related Articles
Comments
May 26, 2009 at 1:42 am
(1) max says:

i had an exam question which asked me why the cell address 1A,IZ10,90BC invalid in MS-Excel?
pls explain!

July 22, 2010 at 5:20 pm
(2) Kermit says:

I think because the cell reference is always in the column then row format. So 1A and 90BC are both invalid references. They should read A1 and BC90.

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.