Jump to content

Welcome to Geeks to Go - Register now for FREE

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
Photo

Excell 2007


  • Please log in to reply

#1
munleyj

munleyj

    Member

  • Member
  • PipPip
  • 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

Advertisements


#2
Neil Jones

Neil Jones

    Member 5k

  • Member
  • PipPipPipPipPipPipPipPip
  • 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

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

Jonesey

    Member

  • Member
  • PipPipPip
  • 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

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP