Results 1 to 3 of 3

If(And formula returning wrong value

Threaded View

  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.

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