Can a calculation ignore text if it occurs in formula's cell range

S

Sally

I have formula strings that include cells that can contain numbers or text.
Can I (easily) create calculations that ingnore text occurances rather than
returning a '#VALUE!'
 
S

Sloth

You have a couple of options. You could use the sum function.
=SUM(A1)
it will return 0, if the cell is text.

There may be other workarounds depending on the formula you want, and
depending on what you mean by "ignore". Post some of them and it might help
us understand a little better.
 
B

B. R.Ramachandran

Hi,

If your formula references only one column (which may contain numbers or
text), say A2:A101, you can use the formula (and drag it down to the last row)

=IF(ISNUMBER(A2),your formula,"")

If your formula references more than one column, use

=IF(ISERROR(your formula),"",your formula)

Regards,
B. R. Ramachandran
 
Top