Blank fields
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Blank fields

  1. #1
    Guest

    Default

     
    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Belgium
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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, "".

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com