#DIV/0! - why?

I insert a formula into my spreadsheet and i end up with the above message. However my formula does not divide by zero. Any ideas?

Chris

Hi Chris,

Please post your formula and the input values

--
Kind regards,

Niek Otten

"cj21" <[email protected]> wrote in message
news:[email protected]...
>
> I insert a formula into my spreadsheet and i end up with the above
> message. However my formula does not divide by zero. Any ideas?
>
> Chris
>
>
> --
> cj21
> ------------------------------------------------------------------------
> cj21's Profile:
> http://www.excelforum.com/member.php...o&userid=25673
> View this thread: http://www.excelforum.com/showthread...hreadid=500186
>

"cj21" <[email protected]> wrote in message
news:[email protected]...
>
> I insert a formula into my spreadsheet and i end up with the above
> message. However my formula does not divide by zero. Any ideas?

Maybe not but I'd bet one of the values passed to the formula does.

In article <[email protected]>, "Danny@Kendal" <[email protected]> wrote:
>"cj21" <[email protected]> wrote in message
>news:[email protected]...
>>
>> I insert a formula into my spreadsheet and i end up with the above
>> message. However my formula does not divide by zero. Any ideas?
>
>Maybe not but I'd bet one of the values passed to the formula does.

Yep. I wonder if one of them is blank ?


Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)