Cell CODE equals #VALUE!

[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

 

[Frank Kabel]

Hi
try using a formula like
=IF(cell_adress<>"",CODE(cell_address),"")

--
Regards
Frank Kabel
Frankfurt, Germany

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?

 

[JulieD]

Hi JC

this should help

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

Cheers
JulieD

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?

 

[Guest]

Hi Julie, both formulas - yours as well as Frank's, worked. Thank you very much
JC