K
Kitty
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.
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.