+ Reply to Thread
Results 1 to 6 of 6

Help, why am I getting "FALSE" output

  1. 11-22-2024, 12:26 AM #1
    hanspet
    hanspet is offline
    Registered User
    Join Date
    11-22-2024
    Location
    Australia
    MS-Off Ver
    365
    Posts
    1

    Help, why am I getting "FALSE" output

    Hi

    This might be an silly mistake Im making, but I can't figure out what the problem is? May be one of you will quickly see the issue.

    Here is the formula Im using:

    =IF(Z1405<=9,"Normal",IF(10<=Z1405<=13,"Mild",IF(14<=Z1405<=20,"Moderate",IF(21<=Z1405<=27,"Severe",IF(Z1405>=28,"Extremely Severe")))))

    Attached is the data its using. When the total is 10 I should get "Mild" but why am I getting FALSE? More importantly, how do I fix it?

    Thanks for any help!
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 11-22-2024, 01:52 AM #2
    sudbhavani
    sudbhavani is offline
    Valued Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    440

    Re: Help, why am I getting "FALSE" output

    Try this formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    If this not working as your recruitment kindly attached the sample sheet
    Last edited by sudbhavani; 11-22-2024 at 01:55 AM.
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Mark Thread as Solved...
    Reply With QuoteRegister To Reply
  3. 11-22-2024, 03:47 AM #3
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,810

    Re: Help, why am I getting "FALSE" output

    Try

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  4. 11-22-2024, 04:07 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,658

    Re: Help, why am I getting "FALSE" output

    To answer your question, you are getting FALSE because there is no VALUE_IF_FALSE in the final argument:

    =IF(Z1405<=9,"Normal",IF(10<=Z1405<=13,"Mild",IF(14<=Z1405<=20,"Moderate",IF(21<=Z1405<=27,"Severe",IF(Z1405>=28,"Extremely Severe","Missing VALUE_IF_FALSE")))))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 11-22-2024, 04:18 AM #5
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: Help, why am I getting "FALSE" output

    Alternatively, =LOOKUP(Z1405,{0,10,14,21,28},{"Normal","Mild","Moderate","Severe","Extremely Severe"})
    Reply With QuoteRegister To Reply
  6. 11-22-2024, 04:25 AM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,303

    Re: Help, why am I getting "FALSE" output

    You can't do this: IF(10<=Z1405<=13,"Mild"

    See sudbhavani's solution in post #2. But you also need a value_if_false in the last IF as Ali suggested in post #4.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    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] Compare "identical" numbers -- false output
    By macrorookie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-07-2022, 01:54 PM
  2. [SOLVED] Searching text for "X" OR "Y" OR "Z" and returning true or false
    By cjcreamer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-28-2021, 02:09 PM
  3. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  4. 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
  5. Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
    By BCB in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-13-2006, 05:02 PM
  6. Insert "-" in text "1234567890" to have a output like this"123-456-7890"
    By Alwyn in forum Excel General
    Replies: 3
    Last Post: 10-25-2005, 07:05 PM
  7. [SOLVED] IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 01:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1