Posted to microsoft.public.excel.worksheet.functions

Angelsnecropolis Angelsnecropolis is offline

external usenet poster

Posts: 5

Whats wrong with this function?

B45 =IF(AVERAGE(B34:D340), AVERAGE(B34:D34),"")

It works fine when there is a number in B34 but if B34 is blank, even though
C34 and D34 are not blank, B45 is still blank.

How can I fix this so a number in any of the 3 fields will produce a number
in B45?

Thanks ^_^

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
Macro - Whats wrong?	NPell	Excel Worksheet Functions	4	September 1st 08 10:51 AM
whats wrong with this?	brownti via OfficeKB.com	Excel Discussion (Misc queries)	10	February 12th 07 02:39 PM
whats wrong with my sorting?	Trisha	New Users to Excel	6	January 17th 06 11:03 AM
Whats wrong with this?	LucasBuck	Excel Discussion (Misc queries)	3	January 12th 06 08:15 PM
Whats Wrong with this??	drvortex	Excel Worksheet Functions	1	October 30th 04 06:48 PM

All times are GMT +1. The time now is 11:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us