Blank fields

[Guest]

Is there a way to leave a resultant field blank when I have a simple computation done from input field but sometimes no input is made so I don't need anything to show up?

example:

I have a field1 that takes a number, then field2 that checks that number against a table, and may or may not compute another number against it. If I don't put a number in field1, I still get a #N/A or O in field2.

I'd like to get nothing in field2 if nothing was put in field1 although field2 does some math.

Thanks

 

[Derek]

Hi
You could word your formulas so that any error returned a zero instead of N/A.
eg =if(iserror(your formula),0,your formula).
Then custom format your cells so that zeros are not displayed eg General;; (that is General followed by 2 semi-colons - this will then only display positive numbers)
If you have formulas in a cell you cannot return them to a totally blank state except by clearing those cells.
Hope this helps
regards
Derek
This message was edited by Derek on 2002-03-08 05:26
This message was edited by Derek on 2002-03-08 05:27

 

[paludgnp]

You solve your problem if you use an:
IF function followed by one ISSOMETHING function in your field2
i.e: field1 = the first cell of a worksheet (A1) type in your field2 the following line:

=if(ISNUMBER(A1),A1,"")

You can also use:
=if(ISNA(A1),"",A1)

It is easy if you use the Fx (insert function) button in the toolbar.

Good luck,
Pierre

 

[Mark W.]

Is there a way to leave a resultant field blank when I have a simple computation done from input field but sometimes no input is made so I don't need anything to show up?

No. All worksheet functions MUST return "something" even if its a null or empty text string, "".