CALCULATION OF A CELL THAT CONTAINS A FORMULA
 

I am trying to simply divide one cell by another. However one of the cells
(A1) contains a formula from another calculation, and no matter what I do it
returns a 0 result.
Eg. =A1/A2 but A1 contains the formula =COUNTIF(F2:F1233,"name") and
a result of 16

CALCULATION OF A CELL THAT CONTAINS A FORMULA
 

How are the cells formatted? What is the value in A2?

If A1/A2 < 0 and cell is formatted as number with 0 decimal places, then you
will 0 as a result

Having a formula in A1 has no impact on the calculation

"Jazzman10" wrote:

I am trying to simply divide one cell by another. However one of the cells
(A1) contains a formula from another calculation, and no matter what I do it
returns a 0 result.
Eg. =A1/A2 but A1 contains the formula =COUNTIF(F2:F1233,"name") and
a result of 16

CALCULATION OF A CELL THAT CONTAINS A FORMULA
 

The cells are formatted 'General', and the value in A2 is 2.

The reason I thought the formula may be causing the problem is I've tried
this on other cells without a formula and it works fine.

"Toppers" wrote:

How are the cells formatted? What is the value in A2?

If A1/A2 < 0 and cell is formatted as number with 0 decimal places, then you
will 0 as a result

Having a formula in A1 has no impact on the calculation

"Jazzman10" wrote:

I am trying to simply divide one cell by another. However one of the cells
(A1) contains a formula from another calculation, and no matter what I do it
returns a 0 result.
Eg. =A1/A2 but A1 contains the formula =COUNTIF(F2:F1233,"name") and
a result of 16

CALCULATION OF A CELL THAT CONTAINS A FORMULA
 

Hi Jazzman,

Try =VALUE(A1)/A2

HTH
Martin

CALCULATION OF A CELL THAT CONTAINS A FORMULA
 

Using your formula in A1, I have 16 in A1, A2=2 and in C1 (=A1/A2) I have the
expected result of 8.

Changing A1 by adding "name" into column F still gives the expected result.
I can only get 0 if column F is empty.

No more ideas!

Post w/book to toppers<atjohntopley.fsnet.co.uk and I'll have a look.

"Jazzman10" wrote:

The cells are formatted 'General', and the value in A2 is 2.

The reason I thought the formula may be causing the problem is I've tried
this on other cells without a formula and it works fine.

"Toppers" wrote:

How are the cells formatted? What is the value in A2?

If A1/A2 < 0 and cell is formatted as number with 0 decimal places, then you
will 0 as a result

Having a formula in A1 has no impact on the calculation

"Jazzman10" wrote:

I am trying to simply divide one cell by another. However one of the cells
(A1) contains a formula from another calculation, and no matter what I do it
returns a 0 result.
Eg. =A1/A2 but A1 contains the formula =COUNTIF(F2:F1233,"name") and
a result of 16

CALCULATION OF A CELL THAT CONTAINS A FORMULA
 

Thank you for both of your help. I've managed to solve it. The example I
gave of A1 and A2 was just that an example. The actual cells I was using
were C577, E577 with the result in F577. Because the formula referred to
F2:F1233 this was where the problem was occurring. I'll make sure if I have
a problem again that I use the actual cells. Thanks again.

"Toppers" wrote:

Using your formula in A1, I have 16 in A1, A2=2 and in C1 (=A1/A2) I have the
expected result of 8.

Changing A1 by adding "name" into column F still gives the expected result.
I can only get 0 if column F is empty.

No more ideas!

Post w/book to toppers<atjohntopley.fsnet.co.uk and I'll have a look.

"Jazzman10" wrote:

The cells are formatted 'General', and the value in A2 is 2.

The reason I thought the formula may be causing the problem is I've tried
this on other cells without a formula and it works fine.

"Toppers" wrote:

How are the cells formatted? What is the value in A2?

If A1/A2 < 0 and cell is formatted as number with 0 decimal places, then you
will 0 as a result

Having a formula in A1 has no impact on the calculation

"Jazzman10" wrote:

I am trying to simply divide one cell by another. However one of the cells
(A1) contains a formula from another calculation, and no matter what I do it
returns a 0 result.
Eg. =A1/A2 but A1 contains the formula =COUNTIF(F2:F1233,"name") and
a result of 16