Support Board

Date/Time: Sat, 18 May 2024 07:58:37 +0000

Post From: #CREF! error

[2017-10-11 17:49:31] Link To Thread - Link To Post [Go To First Post]
User29926 - Posts: 92
Perhaps SC spreadsheet do not fully support a cell reference back to itself? This formula sometimes returns a !CREF error in the $H$64 cell. =IF( AND( $H$90=0,ABS(($H$56 - $H$54)) <= $H$68, SUM(ID64.SG1@3:ID64.SG1@6)) , 1, IF( OR( $J$8 <> 0 , OR ($H$90= 1,OR ($H$62= 1, $E$3 < $H$36)) ) ,0 , IF(ISBLANK($H$64), 0 ,$H$64 ) )) SC docs says this" #CREF! Unable to complete calculation due to a reliance on a circular reference. A circular reference is what happens when a cell references another cell that references back to the first cell. A cell that references itself is not considered a circular reference." The $H$64 cell references itself, so why does IF(ISBLANK($H$64), 0 ,$H$64 ) return a #CREF! error??