Try the below. Count() counts the number of numbers in the range. Here if it
is 2 only we are doing the division or else blank
=IF(COUNT(c45,d45)=2,c45/d45,"")

If this post helps click Yes
---------------
Jacob Skaria


"mexmex" wrote:

Jacob
Thanks again for the help, I am fairly new at the formula bit.
I have another woork sheet with the same issue, it is an amount divided by
the number of days to give an average. =sum(c45/d45) the same issue shows in
the uncalculated cell. unlike my other work sheet the c column is not a
static number.
what in a formula leaves the uncalculated cell empty before any entrys?
6730 10 673
15205 30 507
#DIV/0!
Thanks
--
Max