Formula text attn:Jacob
 

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

Formula text attn:Jacob
 

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

Formula text attn:Jacob
 

Jacob
I think I may have mislead you with my insert, I am doing a divison
calculation not a count one. The first column would be say the number of
units divided by the number of days to get an average number in the third
column without having that other formula in that cell before I enter any
values.
Thanks sorry about the confusion.
--
Max


"Jacob Skaria" wrote:

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

Formula text attn:Jacob
 

The formula I posted does the division only...but before doing that it checks
whether both the numbers are available..

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


"mexmex" wrote:

Jacob
I think I may have mislead you with my insert, I am doing a divison
calculation not a count one. The first column would be say the number of
units divided by the number of days to get an average number in the third
column without having that other formula in that cell before I enter any
values.
Thanks sorry about the confusion.
--
Max


"Jacob Skaria" wrote:

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

Formula text attn:Jacob
 

Thanks Jacob the formula worked for the issue. Now all I have to do is
figure out how to get rid of the zeros that show up in the cell with the
formula when their are no entries in the cells they refer too
--
Max


"Jacob Skaria" wrote:

The formula I posted does the division only...but before doing that it checks
whether both the numbers are available..

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


"mexmex" wrote:

Jacob
I think I may have mislead you with my insert, I am doing a divison
calculation not a count one. The first column would be say the number of
units divided by the number of days to get an average number in the third
column without having that other formula in that cell before I enter any
values.
Thanks sorry about the confusion.
--
Max


"Jacob Skaria" wrote:

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

Formula text attn:Jacob
 

Try
=IF(ISERROR(C45/D45),"",C45/D45)

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


"mexmex" wrote:

Thanks Jacob the formula worked for the issue. Now all I have to do is
figure out how to get rid of the zeros that show up in the cell with the
formula when their are no entries in the cells they refer too
--
Max


"Jacob Skaria" wrote:

The formula I posted does the division only...but before doing that it checks
whether both the numbers are available..

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


"mexmex" wrote:

Jacob
I think I may have mislead you with my insert, I am doing a divison
calculation not a count one. The first column would be say the number of
units divided by the number of days to get an average number in the third
column without having that other formula in that cell before I enter any
values.
Thanks sorry about the confusion.
--
Max


"Jacob Skaria" wrote:

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