Posted to microsoft.public.excel.worksheet.functions

Karen

Posts: n/a

Replace Error with a Dash

I have a cell with the following formula:
{=AVERAGE(IF(B4:M4<0,B4:M4))}
It's producing the infamous #DIV/0! error - When the cell produces this
error, I just want a dash in its place. How can this be done?

Thank you

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
Excel: Add replace within selection functionality	Marcel XL	Excel Discussion (Misc queries)	1	March 3rd 06 01:51 PM
Search and replace	Subu	Excel Worksheet Functions	4	June 9th 05 07:01 PM
replace absolute references	bj	Excel Worksheet Functions	0	May 20th 05 07:18 PM
Replace Number with Text using Macro	Carter68	Excel Discussion (Misc queries)	3	April 19th 05 08:57 PM
VB Find and Replace	Bony_Pony	Excel Worksheet Functions	10	December 6th 04 05:45 PM

All times are GMT +1. The time now is 06:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us