#DIV/0!
From the HELP..........
What does the error #DIV/0! mean?
The #DIV/0! error value occurs when a formula divides by 0 (zero).
Possible cause Suggested action
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.
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.
Vaya con Dios,
Chuck, CABGx3
"Jim S" wrote in message
...
What does #DIV/0! mean when it shows up in a cell with a formula?
--
Jim S
|