Results 1 to 10 of 10

Nested If Statement - ISBLANK and ISNA in same statement?

Threaded View

  1. #1
    Registered User
    Join Date
    10-30-2009
    Location
    UK
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    60

    Nested If Statement - ISBLANK and ISNA in same statement?

    Hi Everyone

    I have the following formula and would like to add to it but I'm not sure where to create the additional argument:


    =IF(ISNA(VLOOKUP($A6,Sheet5!$A$3:Sheet5!$E$389,2,FALSE)),"-",VLOOKUP($A6,Sheet5!$A$3:$E$389,2,FALSE))


    Where the ISNA is false, it currently returns a zero value regardless that the cell it's copying from is blank - I would like this to show as "-" rather than a zero. I'm sure this must be possible, as I've used ISBLANK previously, I just don't know where to insert it into my formula.

    Thanks in advance for any help.

    Jan
    Last edited by Janc; 04-23-2013 at 05:19 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1