Getting true blank cell v ""
Thanks Gary!
--
Thank you -- Suzanne.
"Gary''s Student" wrote:
COUNTA() counts these pseudo-empty cells. If you want to exclude them from a
tally, use COUNT() instead.
--
Gary''s Student - gsnu200792
"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.
|