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


"Sally" wrote:

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!'