Login Page - Create Account

Support Board


Date/Time: Tue, 01 Jul 2025 08:07:06 +0000



Post From: #CREF! error

[2017-10-12 19:01:37]
Jeffrey - Posts: 2276
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.