Cell CODE equals #VALUE!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data file that contains numbers and blank cells. Using the formula =Code(cell address) I get returns of 45, 48, 50, 53, etc for cells populated with numbers. And, I get #VALUE! for blank cells. These blank cells cause problems when attempting totals. Could someone tell me how can I fix this problem
Thanks
JC
 
Hi
try using a formula like
=IF(cell_adress<>"",CODE(cell_address),"")

--
Regards
Frank Kabel
Frankfurt, Germany

JC said:
I have a data file that contains numbers and blank cells. Using the
Click to expand...
formula =Code(cell address) I get returns of 45, 48, 50, 53, etc for
cells populated with numbers. And, I get #VALUE! for blank cells.
These blank cells cause problems when attempting totals. Could someone
tell me how can I fix this problem?
 
Hi JC

this should help

=IF(ISERROR(CODE(A1)),0,CODE(A1))

Cheers
JulieD

JC said:
I have a data file that contains numbers and blank cells. Using the
Click to expand...
formula =Code(cell address) I get returns of 45, 48, 50, 53, etc for cells
populated with numbers. And, I get #VALUE! for blank cells. These blank
cells cause problems when attempting totals. Could someone tell me how can I
fix this problem?
 
Back
Top