I have a column in which each cell has the following formula (adjusted of course for line number, etc.)....
The cell has a calculated or entered value. so, the operator will, more often than not, enter a dollar amount in the cell. The problem is when they change their mind and remove their entry, the resident formula is gone.
I wrote the following formula in a non-printing area to test for the contents of the cell: =IF(K20="","K20 is Empty","K20 is OK") but for some reason it only works if there is a dollar value present. The formula is not able to detect the presence of the resident formula. What am I doing wrong?