+ Reply to Thread
Results 1 to 3 of 3

Return #NA if result is equal to "0"

  1. 03-26-2017, 06:33 PM #1
    matrixpom
    matrixpom is offline
    Forum Contributor
    Join Date
    04-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    329

    Return #NA if result is equal to "0"

    Hey guys,

    I have a formula for looking up the current month & returning a cell value from that column. Problem is I need the code to return "#NA" when the value returned equals zero
    My current code is 
    Please Login or Register  to view this content.
    I've tried a basic "If" function to no avail 
    Please Login or Register  to view this content.
    , any ideas? As always thanks for any assistance guys, Marco
    Reply With QuoteRegister To Reply
  2. 03-26-2017, 06:36 PM #2
    spitfireblue
    spitfireblue is offline
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Return #NA if result is equal to "0"

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.
    Reply With QuoteRegister To Reply
  3. 03-26-2017, 07:21 PM #3
    matrixpom
    matrixpom is offline
    Forum Contributor
    Join Date
    04-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    329

    Re: Return #NA if result is equal to "0"

    Works like a charm! Thank you spitfireblue - Marco
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to return a result by matching part of a cell using "INDIRECT".
    By Alac61 in forum Excel General
    Replies: 8
    Last Post: 05-02-2015, 09:27 AM
  2. If Vlookup finds result, return specific "Phrase"
    By rwmeis in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-21-2013, 08:43 AM
  3. [SOLVED] Return Values in a range not equal to "" criteria. (No Blanks.)
    By acepaul in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-20-2013, 03:30 PM
  4. Excel 2007 : Match Values and Return "Present" "Absent" "Per Diem" or remain blank
    By DanBraden in forum Excel General
    Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  5. Formula returning result of "True" or "False" instead of "1" or "0"
    By AllenMead in forum Excel General
    Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  6. [SOLVED] return a cell contents as the result of usiing "small"
    By KFEagle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2005, 08:07 PM
  7. [SOLVED] "=RESULT()", "=ARGUMENT()", "=RETURN()" ??
    By PeteCresswell in forum Excel General
    Replies: 1
    Last Post: 03-31-2005, 04:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1