CALCULATION OF A CELL THAT CONTAINS A FORMULA

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[MartinW]

Hi Jazzman,

Try =VALUE(A1)/A2

HTH
Martin

 

[Guest]

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<at>johntopley.fsnet.co.uk and I'll have a look.

 

[Guest]

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.