Forum Discussion
Solved
How to test for an empty numeric cell
I have a table with a numeric column with several rows of empty cells interspersed some rows of cells with a value. I tried the following formula without success, even though it uses similar syntax a...
wcstarks You should use the following syntax.
=IF([@CGMAve] = "", "", [@CGMAve]*1.18)Note the @sign in front of the column name!
Without it, you are entering a dynamic array formula inside a structured table. That's not allowed and it will produce a #SPILL! error. I suspect that the column with ### is just too narrow to display the error. Widen it and see.
@ makes the formula refer to the specified column in the same row as the cell with the formula
Thanks. Now that you mention it, I see in your other posts, you did say that before. I think it will finally stick in my memory now.