Results 1 to 3 of 3
  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Hiding Results (MSO 03)

    A while back there was a post that had to do with hiding results that came up with for example the #VALUE, I didnt copy that post as I usually do, and now find that I am in need of doing that. Anyone remember that post #?
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Hiding Results (MSO 03)

    If you have a formula in a cell like:
    =Formula

    and you want to hide it when it results in an error. You just use:
    =if(iserror(formula),"",formula)

    For example:
    =A1/B1

    becomes:
    =if(iserror(A1/B1),"",A1/B1)

    Steve

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Hiding Results (MSO 03)

    Thank You
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

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