Closed swcurran closed 1 year ago
When loaded in Excel, the error is flagged as an inconsistent formula. Instead of referencing cell B7, the cell B12 is incorrectly referenced.
B7
B12
Error: =IF(AND(NOT(ISBLANK(A$4)),NOT($B12="")),A$4,"") Fix. =IF(AND(NOT(ISBLANK(A$4)),NOT($B7="")),A$4,"")
=IF(AND(NOT(ISBLANK(A$4)),NOT($B12="")),A$4,"")
=IF(AND(NOT(ISBLANK(A$4)),NOT($B7="")),A$4,"")
There is also some odd formatting on the Documentation tab -- the "Conditional" section, but I'm not sure if that is intentional or not.
When loaded in Excel, the error is flagged as an inconsistent formula. Instead of referencing cell
B7, the cellB12is incorrectly referenced.Error:
=IF(AND(NOT(ISBLANK(A$4)),NOT($B12="")),A$4,"")Fix.=IF(AND(NOT(ISBLANK(A$4)),NOT($B7="")),A$4,"")There is also some odd formatting on the Documentation tab -- the "Conditional" section, but I'm not sure if that is intentional or not.