ChatterBank5 mins ago
Excel Forumla Help
7 Answers
When I do a spreadsheet which is formulated
I get #DIV/0! (as the cells do not include any data, I think)
How do I make this 0 ?
TIA if you can help
I get #DIV/0! (as the cells do not include any data, I think)
How do I make this 0 ?
TIA if you can help
Answers
Best Answer
No best answer has yet been selected by sunflower71. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Got this from typing #DVI/0 into excel help.
(double dutch to me !)
Using the cell reference to a blank cell or to a cell that contains zero as a divisor. (If an operand is a cell that is blank, Microsoft Excel interprets the blank as zero.) Change the cell reference, or enter a value other than zero in the cell used as a divisor. You can enter the value #N/A into the cell referenced as the divisor, which will change the result of the formula to #N/A from #DIV/0! to denote that the divisor value is not available.
To prevent an error value from displaying, use the IF worksheet function. If the cell used as the divisor is blank or contains a zero (0), then the IF function can display nothing instead of performing the calculation. For example, if cell B5 contains the divisor and A5 contains the dividend, use =IF(B5=0,"",A5/B5). The two quotation marks represent an empty text string.
Entering a formula that contains explicit division by zero (0) � for example, =5/0. Change the divisor to a number other than zero.
Running a macro that uses a function or a formula that returns #DIV/0!. Make sure the divisor in the function or formula is not zero or blank.
(double dutch to me !)
Using the cell reference to a blank cell or to a cell that contains zero as a divisor. (If an operand is a cell that is blank, Microsoft Excel interprets the blank as zero.) Change the cell reference, or enter a value other than zero in the cell used as a divisor. You can enter the value #N/A into the cell referenced as the divisor, which will change the result of the formula to #N/A from #DIV/0! to denote that the divisor value is not available.
To prevent an error value from displaying, use the IF worksheet function. If the cell used as the divisor is blank or contains a zero (0), then the IF function can display nothing instead of performing the calculation. For example, if cell B5 contains the divisor and A5 contains the dividend, use =IF(B5=0,"",A5/B5). The two quotation marks represent an empty text string.
Entering a formula that contains explicit division by zero (0) � for example, =5/0. Change the divisor to a number other than zero.
Running a macro that uses a function or a formula that returns #DIV/0!. Make sure the divisor in the function or formula is not zero or blank.
This shows you how to stop it appearing, http://support.microsoft.com/kb/182188
well why are you trying to divide �0 by 0? the answer to that would be infinity so the computer sees it as an error your formula.. I can only presume your are going to be changing the field so that you're not actually dividing by 0? If that's the case, it'll all be ok as soon as you input the relevant data.