View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 98
Default If IsNumber or IsNumeric

Kitty,

if you look up the ISERR or ISERROR functions in Help, that should help you out. Using one of these functions in your IF function
should do what you need it to.

I hope this helps,

Conan


"Kitty" wrote in message oups.com...
I'm not an excel formula pro and am struggling. Can anyone help?
I've got a column of data, say C1:C10. The contents of ea. cell in
this column are derived from a formula in another workbook. The C
cells can be populated with either a number or #N/A N.A.

I'm trying to create a formula that results in the new cell showing the
number if the C cell holds a number, but also shows a 0 if the C cell
shows #N/A N.A.

Here's what I've got (and I've tried both isnumber and isnumeric).
=IF(IsNumber C1:c10, C1:c10, 0).

I'm sure this is pretty simple but I can't make it work. Thanks for
any ideas.