Support Board
Date/Time: Thu, 16 Jan 2025 09:39:59 +0000
Post From: #CREF! error
| [2017-10-11 17:49:31] |
| 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?? |