View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.