#DIV/0! error help

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
How can I get the cell to be blank rather than show this error? My formula in the cell is: =AVERAGE(D6:D18)

This is used in a calendar type application and obviously, for the months that haven't occured yet there will be "errors". I'd rather not have this error all over my sheet. Thanks!!!
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Explain a bit more - when months are 'incomplete' do you still wish an average?
 

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
Jon, no average is needed if the months are incomplete. I just was hoping to clean up the "results" for months that haven't happened yet. What this is used for is there is a feed from a database which pulls in stats for employees (D6:D18). I then average the stats to get an average for each unit. Like I said, the error occurs for each month that has yet to occur.
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Then BfM's got you covered - Howdy, Brian - been teeing it up lately?
 
L

Legacy 51064

Guest
=if(iserror(AVERAGE(D6:D18)),"",AVERAGE(D6:D18))

I had an extra = sign in the equation.
 

Forum statistics

Threads
1,078,008
Messages
5,337,704
Members
399,162
Latest member
Sabina

Some videos you may like

This Week's Hot Topics

Top