Posted to microsoft.public.excel.worksheet.functions

Nicola

external usenet poster

Posts: 10

Ignoring error values in a formula

Hi, please help I need to add 2 cells together but in some cases there is an
error (#N/A) value in one of cells. How can I ignore the #N/A but still
return the value of the other cell? Everything I've tried returns the value
#N/A. Please help!!

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Reusing formula	Tony29	Excel Discussion (Misc queries)	7	September 7th 06 03:34 AM
Copy formula with skipping rows	Fewebber	Excel Worksheet Functions	0	June 6th 06 04:12 PM
Locking portions of a formula	tiggatattoo	Excel Worksheet Functions	2	June 5th 06 04:51 PM
Ignoring #DIV/0! in a formula	DLZ217	Excel Discussion (Misc queries)	2	April 26th 05 10:01 AM
Formula to average ignoring negatives?	Steve	Excel Discussion (Misc queries)	16	January 1st 05 12:57 PM

All times are GMT +1. The time now is 09:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us