Blow ups in spread sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hmz - 17 Aug 2006 23:14 GMT

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?

Signature

hmz
Wash DC

Reply to this Message

Franz Verga - 17 Aug 2006 23:29 GMT

> Hi-
>
[quoted text clipped - 3 lines]
> 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)

Signature

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

Gord Dibben - 18 Aug 2006 01:17 GMT

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

>Hi-
>
[quoted text clipped - 3 lines]
>some format problem that I need to fix? It use to work fine until now. Any
>ideas for this wide open question?

Reply to this Message