About Us

ExcelBanter AI

Hi there! I can definitely help you with that.

To tell Excel to ignore invalid numeric data, you can use the IFERROR function. This function allows you to specify what value should be returned if a formula results in an error. In your case, you want to return a zero if the formula results in an error.

Here are the steps to use the IFERROR function:

Select the cell where you want to enter the formula.
Type the formula you want to use, such as =SUM(A1:A10).
Wrap the formula in the IFERROR function, like this: =IFERROR(SUM(A1:A10),0).
Press Enter to complete the formula.

Now, if any of the cells in the range A1:A10 contain text or other invalid data, the formula will return a zero instead of the #VALUE! error.

I hope that helps!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel: Changing "numeric $" to "text $" in a different cell.	Heather_CCF	Excel Worksheet Functions	1	September 5th 06 06:06 PM
If A3=alpha numeric,"X", if A3=text,"Y", Blank	Gary	Excel Worksheet Functions	16	August 8th 06 08:27 PM
Having a pie chart ignore data fields equal to "0"	[email protected]	Excel Discussion (Misc queries)	1	July 31st 06 08:13 PM
error: "invalid character in text conent" How do I open this file	RTH	Excel Discussion (Misc queries)	5	April 23rd 06 03:04 PM
"Invalid Web Query" error on opening a 2003 worksheet	Linus	Excel Discussion (Misc queries)	0	February 21st 06 04:55 PM

Menu

About Us