Hi-

I have a workbook with formula's throughout. If I put an input variable,
the formula would work. Now, if I change the number, other than 32, it blows
up, and I have "N/A" throughout the workbook where my formula are. Is there
some format problem that I need to fix? It use to work fine until now. Any
ideas for this wide open question?
--
hmz
Wash DC

hmz wrote:
Hi-

I have a workbook with formula's throughout. If I put an input
variable, the formula would work. Now, if I change the number, other
than 32, it blows up, and I have "N/A" throughout the workbook where
my formula are. Is there some format problem that I need to fix? It
use to work fine until now. Any ideas for this wide open question?

I think it depends on which formula do you have in your workbook...

To avoid the #N/A error you can incapsulate your formulas with an IF
function:

=IF(ISNA(your_formula),"",your_formula)


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

What Function are you using(s)?

Post one of the formulas that blows up when you enter a number other than 32


Gord Dibben MS Excel MVP

On Thu, 17 Aug 2006 15:14:01 -0700, hmz wrote:

Hi-

I have a workbook with formula's throughout. If I put an input variable,
the formula would work. Now, if I change the number, other than 32, it blows
up, and I have "N/A" throughout the workbook where my formula are. Is there
some format problem that I need to fix? It use to work fine until now. Any
ideas for this wide open question?