iserror formula eliminating zeros

[moncty]

I currently have a spreedsheet broken down by month with
a iserror formula calculating a percentage value,
however, with this formula it is calculating 0% even
before I have placed any values in the cells for future
months. I only want to elimante 0% calculations on
future months if no values have been placed in the
appropriate cells, whereas, show the 0% on those months
that I have entered values in the appropriate cells and
the actual calculation equals 0%. Is there a way to
accomplish this?

The current formula I am using is:
=IF(ISERROR(B10/B9),0,B10/B9)

 

[Dave R.]

Have you tried

=IF(ISERROR(B10/B9),"",B10/B9)

?

You don't list where the 'future monthS' can be held, that would make it
easier to put together something if the above isn't useful.

 

[Frank Kabel]

Hi
try
=IF(ISERROR(B10/B9),"",B10/B9)