Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Excell 2007

### #1 munleyj Posted 06 November 2009 - 04:15 PM

munleyj

Member

• Member
• 91 posts
How do I get rid of #DIV/0! with these formulas?

=IF(OR(B10>0,C10>0),AVERAGE(B10:C10)," ")

=IF(AND(D10<65,D10<>0),65-D10,0)

=IF(AND(D11>65,D11<>0),D11-65,0)
• 0

### #2 Neil Jones Posted 06 November 2009 - 04:33 PM

Neil Jones

Member 5k

• Member
• 8,476 posts
Without knowing anything else about the spreadsheet, nobody knows. What are the figures in columns B, C and D?

A Division by Zero error is obviously caused when you divide a number zero, and the common error is typically caused by the cells in question being empty or non numerical, which returns the values as zero. This may be because the sheet is referencing the wrong cells.
• 0

### #3 Vino Rosso Posted 06 November 2009 - 04:58 PM

Vino Rosso

Visiting Staff

• Visiting Consultant
• 235 posts
I don't get #DIV/0! errors with the formulae by themselves but then, as Neil Jones has said, we would need the data in B10, C10, D10, and D11.
• 0

### #4 Jonesey Posted 09 November 2009 - 05:45 AM

Jonesey

Member

• Member
• 335 posts
Well, the 2nd & 3rd formulae shouldn't be generating a #DIV/0! error in any case as there's nothing being divided.

The only thing that can cause that is if cells D10 or D11 is returning the error to start with, so as the other 2 have said, what's the contents of the cells.
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users