Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a calculation ignore text if it occurs in formula's cell range
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!' |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a calculation ignore text if it occurs in formula's cell range
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. "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!' |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a calculation ignore text if it occurs in formula's cell range
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!' |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Cell Range with Text | Excel Worksheet Functions | |||
macro help | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Can I use formulas that return cell range ref. in charts X series | Charts and Charting in Excel | |||
How do I use text in a cell as a range name in a formula | Excel Discussion (Misc queries) |