Posted to microsoft.public.excel.worksheet.functions

MCheru

external usenet poster

Posts: 70

Eliminating #DIV/O!

I have this formula =SUM(AVERAGE(N4:N200)). Right now #DIV/O! appears if
N4:N200 does not have any data to report. Is it possible to modify this
formula so that the cell the formula is in reports a zero €œ0€ if it does not
have any data to report?

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
#N/A and eliminating it.	Ted	Excel Discussion (Misc queries)	2	April 24th 07 05:26 PM
eliminating records!	via135 via OfficeKB.com	Excel Worksheet Functions	2	November 12th 06 10:32 AM
eliminating the 0 in DIV/0	teacher1	Excel Discussion (Misc queries)	11	September 13th 06 09:28 PM
Eliminating #N/A	Mike	Excel Worksheet Functions	4	December 14th 05 07:34 PM
Eliminating every 25th row	Lram	Excel Worksheet Functions	5	October 16th 05 11:07 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us