Getting true blank cell v ""
A formula cannot return a truly blank result - the cell contains the
formula after all !
You can count blanks and formula blanks like this:
=COUNTIF(A1:A10,"")
Hope this helps.
Pete
On Jun 16, 1:28*pm, Suzanne wrote:
Good morning. In formulas i typically use a false value of "" * to present or
store the result as a 'blank' cell. *When i copy and paste the value of the
formulas and counta or countif range 0, Excel counts this cell. *Should i
be using something other than "" if my result is false and want the cell to
be empty/truly blank? *
--
Thank you -- Suzanne.
|