iserror formula eliminating zeros

  • Thread starter Thread starter moncty
  • Start date Start date
M

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)
 
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.
 
Back
Top