Posted to microsoft.public.excel.worksheet.functions

malcolm

external usenet poster

Posts: 57

Averaging without #DIV0!

Im using a worksheet that has a cell (C27) that totals rooms and a cell
(J28) that totals rates and a cell (J29) that is the average daily rate
total, rate/total rooms. Im using the formula =AVERAGE(J28/C27). The only
problem is until I actually input a number into C27 I get the #DIV/0!
displayed in my ADR cell (J29). I dont always need this data so is there a
way I can input the formula and not have the #DIV/0! in cell J29?
Thanks,
Malcolm

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
How do I weight numbers when some are zero without getting DIV0	Drewfus	Excel Worksheet Functions	2	May 2nd 09 04:54 PM
#VALUE & #DIV0	tonyalt3	Excel Worksheet Functions	2	January 9th 08 01:46 PM
IRR & #DIV0!	David	Excel Worksheet Functions	4	January 23rd 07 05:13 PM
I WANT TO HIDE THIS #DIV0!	HERNAN	Excel Discussion (Misc queries)	9	July 26th 06 07:28 PM
#DIV0/! issues	Brento	Excel Discussion (Misc queries)	2	February 2nd 06 07:52 AM

All times are GMT +1. The time now is 05:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us