+ Reply to Thread
Results 1 to 2 of 2

Implementing NA() in this formula

  1. #1
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Implementing NA() in this formula

    Hey there, this is a formula for graph data and the last point on my graph goes to zero. How do i implement na() into this formula and only show actual data on my graph?

    =IF($D206>DATE('Date Key'!$B$9,'Date Key'!$B$8,1), NA(), (INDEX('Income Q'!$1:$1048576,MATCH('Graph Data Income'!$D206,'Income Q'!$A:$A,0),MATCH('Graph Data Income'!AU$205,'Income Q'!$4:$4,0))))

    Thanks,

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Implementing NA() in this formula

    =IF($D206>DATE('Date Key'!$B$9,'Date Key'!$B$8,1), "", INDEX('Income Q'!$1:$1048576,MATCH('Graph Data Income'!$D206,'Income Q'!$A:$A,0),MATCH('Graph Data Income'!AU$205,'Income Q'!$4:$4,0)))

    If the logic test is true, it will leave a blank. Blank values are left blank on a graph, whereas a NA will default to zero.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Implementing ISNA formula into equation.
    By JPSIMMON in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2013, 06:26 PM
  2. Need help in implementing same formula for different files
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2012, 11:14 PM
  3. Implementing mailto in macro
    By jamer02 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2011, 06:56 AM
  4. Implementing an idea ...
    By SunGod87 in forum Excel General
    Replies: 1
    Last Post: 12-19-2005, 10:51 AM
  5. [SOLVED] New at VB, need help implementing simple commands...
    By Nina Hibbler in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-22-2005, 07:10 PM

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