pivot tables, calculated fields, empty cells and zeros
 

Excel 2000.

I have a calculated field in my pivot table that simply divides one field by
another.

The formula is =my_numerator/my_denominator.

The underlying data in the numerator field can legitimately be
a) an integer greater than or equal to zero, or
b) an empty cell. The empty cell and zero are NOT the same thing.

What I want is:
a) When my_numerator is zero and is divided by my_denominator, a zero is
returned.
b) When my_numerator is the empty cell and is divided by my_denominator, an
empty cell is returned.

At the moment, when my_numerator is the empty cell and is divided by
my_denominator, a zero is returned, which is incorrect.

What can I do?

Regards

GPO

pivot tables, calculated fields, empty cells and zeros
 

Hi GPO,

ISBLANK should fix that for you, something like
=IF(ISBLANK(my_numerator),"",my_numerator/my_denominator)

HTH
Martin

"GPO" wrote in message
...
Excel 2000.

I have a calculated field in my pivot table that simply divides one field
by
another.

The formula is =my_numerator/my_denominator.

The underlying data in the numerator field can legitimately be
a) an integer greater than or equal to zero, or
b) an empty cell. The empty cell and zero are NOT the same thing.

What I want is:
a) When my_numerator is zero and is divided by my_denominator, a zero is
returned.
b) When my_numerator is the empty cell and is divided by my_denominator,
an
empty cell is returned.

At the moment, when my_numerator is the empty cell and is divided by
my_denominator, a zero is returned, which is incorrect.

What can I do?

Regards

GPO