+ Reply to Thread
Results 1 to 3 of 3

If(And formula returning wrong value

  1. #1
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    If(And formula returning wrong value

    Hello everyone

    I have the formula below that works for the most part, except if the value is empty, it returns "75+" and I'm not sure why. Everything else works fine.

    Thoughts?

    HTML Code: 
    Last edited by AccountingJ; 02-04-2019 at 03:51 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,797

    Re: If(And formula returning wrong value

    When J2 is empty, I get 0-15.

    I would do it like this. IMHO it's more readable and easier to update.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: If(And formula returning wrong value

    A lot easier to update for sure! Thank you Jazzer.

+ 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. [SOLVED] Need help with returning combinations - I am not sure what is wrong with my formula?
    By GAJT73 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2018, 04:41 PM
  2. [SOLVED] IF Formula returning wrong answer
    By Abyrose in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-01-2014, 11:30 PM
  3. [SOLVED] Index formula returning wrong row refferences
    By JO505 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-26-2013, 05:08 PM
  4. IF formula returning wrong value!
    By Robotacha2010 in forum Excel General
    Replies: 4
    Last Post: 06-22-2011, 10:49 AM
  5. part of formula returning wrong results
    By johnmerlino in forum Excel General
    Replies: 6
    Last Post: 11-15-2010, 11:24 AM
  6. Index Max Match formula returning wrong value
    By bk77 in forum Excel General
    Replies: 4
    Last Post: 03-25-2009, 02:17 PM
  7. Array formula returning wrong results
    By TUNGANA KURMA RAJU in forum Excel General
    Replies: 1
    Last Post: 11-19-2005, 06:35 AM

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