Eliminate #Value! in fields

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I have a weekly report for all of 2004. There are two
main columns. The first is weekly sales and the second
is forecasted sales. I have a formula in a third column
that divides weekly sales by forecasted sales. For future
weeks, the numerator which is weekly sales is blank. The
demoniator contains a value for all 52 weeks. My values
that appear in the third column with the formula has a
value of #VALUE!. Once the actual sales are filled in,
the the #VALUE! dissapears and a percentage appears. How
do I make is so the #VALUE! does not appear at all and
the formula column is blank until the actual sales
(numerator) has a value?

Thanks,

Chuck
 
Chuck

Without seeing your formula(s) this would be a guess only.

Example..... =IF(numerator="","",numerator/denominator)

Gord Dibben Excel MVP
 
Seems the easiest way is to create a formula:

IF('denominator'="","",'numerator'/'denominator')

That way, it will show nothing until you populate the column to match the
weekly sales.

Hi,

I have a weekly report for all of 2004. There are two
main columns. The first is weekly sales and the second
is forecasted sales. I have a formula in a third column
that divides weekly sales by forecasted sales. For future
weeks, the numerator which is weekly sales is blank. The
demoniator contains a value for all 52 weeks. My values
that appear in the third column with the formula has a
value of #VALUE!. Once the actual sales are filled in,
the the #VALUE! dissapears and a percentage appears. How
do I make is so the #VALUE! does not appear at all and
the formula column is blank until the actual sales
(numerator) has a value?

Thanks,

Chuck
 
Back
Top