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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formulas that may sometimes contain empty cells 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Excel formula, sum the value cell and if empty cell left blank 0
Select a range not equal to: 4
count - but exclude counting cells with a formula 4
Create a formula by joining text and the value from a formula 3
using the =page! feature to transpose a row to column 0
Sumproduct Ignore Text 2

Back
Top