Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 04:05:32 +0000

How to Post a Message for Support

Post From: #CREF! error

[2017-10-12 19:01:37]
[Go To First Post]
Jeffrey - Posts: 2103
If a cell references another cell that has an error in it, the first cell will show that same error.

For example, both of these cells will display #CREF!:
A1:=A2
A2:=#CREF!

You can use the Details button at the upper-right of the spreadsheet window to see which reference in a formula evaluates to an error. See Viewing Formula Expression Tree for details.