Excell 2007, #DIV/0! |
Need a geek? Geeks to Go offers free, quality tech support -- in terms anyone can understand. Volunteers are waiting to help, friendly, technology experts who have knowledge to share, and enjoy helping others. Feel free to browse the site as a guest. However, you must log in to reply to existing topics, or to start a new topic of your own. Other benefits of joining include richer forum features, and removal of all advertising. Learn more in our Welcome Guide Infected? Malware and Spyware Cleaning Guide. What are you waiting for? Click here to join for free today!
|
|
|
  |
 Nov 6 2009, 04:15 PM
Post
#1
|
|
|
Member  Posts: 54 OS: 98  |
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) |
 |
 
|
|
Nov 6 2009, 04:33 PM
Post
#2
|
|
|
Member 5k Posts: 6,859 From: UK OS: Windows XP Home Edition Service Pack 3 |
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. |
|
|
|
|
Nov 6 2009, 04:58 PM
Post
#3
|
|
 Visiting Staff  Posts: 132 OS: Rubber Band |
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.
|
|
|
|
|
Nov 9 2009, 05:45 AM
Post
#4
|
|
 Member Posts: 291 From: Bristol, England OS: Windows XP Professional, SP3 |
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. |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
Similar Topics
| Topic Title | Replies / Views | Topic Information | |||||
|---|---|---|---|---|---|---|---|
 |
0 / 45 | 17th November 2009 - 06:02 AM Jonesey started - last by Jonesey |
|||||
|
0 / 27 | 17th November 2009 - 05:33 PM foil1 started - last by foil1 |
|||||
|
 |
0 / 30 | 18th November 2009 - 05:15 AM littlepaws started - last by littlepaws |
||||
|
0 / 6 | Today, 01:57 AM chrissiedoll started - last by chrissiedoll |
|||||
|
Time is now: 21st November 2009 - 05:52 AM |
Advertisements do not imply our endorsement of that product or service. The forum is run by volunteers who donate their time and expertise. We make every attempt to ensure that the help and advice posted is accurate and will not cause harm to your computer. However, we do not guarantee that they are accurate and they are to be used at your own risk. All trademarks mentioned on this page are the property of their respective owners.
© Geeks to Go, Inc. | All Rights Reserved | Privacy Policy | Advertising