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.
wcstarks There are several ways to view the name of the table:
- Select the entire table without its header row. You'll see the name in the box on the left hand side of the formula bar.
- Click anywhere in the table. Activate the Table Design tab of the ribbon. You'll see the name in the Properties group.
- Click Name Manager on the Formulas tab of the ribbon.
- Press F5 to activate the Go To dialog.
You can edit the table name in each of the above options except the last one.
I had incorrectly included the header in the selection, thinking it was part of the table, and that did not show the name. I also fixed the other dependent column (O). Thanks again.