Results 1 to 9 of 9

IF statement not returning correct answer

Threaded View

  1. #1
    Registered User
    Join Date
    12-01-2016
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    4

    IF statement not returning correct answer

    SOLVED
    I'm having trouble with an IF formula.

    My data is a number between -1 to -49 and 50 to 1. I'm trying to categorize this range into several categories.

    -1 to -5 = "Backed Up"

    -6 to -20 = "Yellow Zone"

    -21 to +21 = "Green Zone"

    +20 to +12 = "Hi Red Zone"

    +11 to +4 = "Lo Red Zone"

    +3 to +1 = "Goal Line"

    I've tried this, but it does not return the correct answer:

    =IF(E41>=-20,"Green Zone", IF(E41>=20,"Hi Red Zone", IF(E41>=12, "Lo Red Zone", "Goal Line")))

    if e41 = -25

    ANY Help would be greatly appreciated!!

    Thank you!
    Attached Files Attached Files
    Last edited by speedrazer; 01-23-2021 at 12:40 PM. Reason: solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF statement not returning correct result
    By kenny scott in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-09-2020, 10:01 AM
  2. IF statement not returning correct value
    By bdouglas1011 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2018, 11:37 AM
  3. Replies: 3
    Last Post: 07-12-2016, 05:05 PM
  4. Formula not returning correct answer
    By rschase1863 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2011, 11:06 PM
  5. Formula sometimes returning correct answer and sometimes returning 0
    By redimp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2010, 06:28 AM
  6. LOOKUP Formula not returning correct answer
    By preferiti in forum Excel General
    Replies: 10
    Last Post: 04-17-2009, 12:30 AM
  7. VLOOKUP not returning correct answer
    By Alan Davies in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2006, 10:40 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