» Average Issues???
Post at 2011-5-24 17:36
This Author's Posts Only
My formula is =AVERAGE(A1:A5). When all cells (A1:A5) are empty, my answer is #DIV/0!. How do I make #DIV/0! = empty cell?
A few options... one would be to check that the range contains at least one numerical value:
EDIT: above is an exact copy of excelR8R's post!
Web query macro Login and copy data to Excel
Sansui 771 or Pioneer SA-6700
Hi, Just joined the forum
Infinities and Baby Advents
calculate payroll hours from time card
Add code for keyboard ESC button into macro
Pull Table Columns based on Column Heading
Formula Explaination, Help PLEASE!
Summing frequencies in a range
Struggling to fix macro
How the print look different, the cell format is same
Copy Excel Name Constants to another workbook
Help with nested VBA If statement
If macros are diabled at security prompt, how to prevent workbook from opening?
IF AND Forumla... I think
Find in column A and add in column B
Code to match two sheets and display differences
Dropdown box empty???
Tab through all the Worksheet with Tab Color
Copy and Paste to a user form
Concatenate with space inbetween?
VBA Find/Replace in Word from Excel
GMT+8, 2013-6-19 16:45.