Support Board

Date/Time: Sat, 18 May 2024 05:12:31 +0000

Post From: #CREF! error

[2017-10-12 19:36:16] Link To Thread - Link To Post [Go To First Post]
Jeffrey - Posts: 2103
Looking at the formula in your first post, the self-references back to $H$64 are probably not causing the issue. My guess is that one of the other cells referenced by that formula has an error value. You can confirm this by using the Details button mentioned in the previous post. You can double-click on cell references that have an error value in the details window to jump to the referenced cell, and you can repeat this for each cell you jump-to to trace the error back to its origin.