+ Reply to Thread
Results 1 to 8 of 8

How can I get a value to return "Y" OR "N" instead of true or false

  1. 03-04-2014, 04:06 PM #1
    bunnyfrostr
    bunnyfrostr is offline
    Registered User
    Join Date
    03-03-2014
    Location
    us
    MS-Off Ver
    Excel 2013
    Posts
    17

    How can I get a value to return "Y" OR "N" instead of true or false

    =OR([@[First Time]]=2016, [@[2016 Sales]]>= 400000)
    how could i edit this forumula so that it can say Y or N
    Reply With QuoteRegister To Reply
  2. 03-04-2014, 04:09 PM #2
    TMS
    TMS is online now
    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
    44,419

    Re: How can I get a value to return "Y" OR "N" instead of true or false

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



    Regards, TMS
    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
  3. 03-04-2014, 04:09 PM #3
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: How can I get a value to return "Y" OR "N" instead of true or false

    =IF(OR([@[First Time]]=2016, [@[2016 Sales]]>= 400000) ,"Y", "N")
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  4. 03-04-2014, 04:12 PM #4
    bunnyfrostr
    bunnyfrostr is offline
    Registered User
    Join Date
    03-03-2014
    Location
    us
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: How can I get a value to return "Y" OR "N" instead of true or false

    Quote Originally Posted by TMShucks View Post
    Formula: copy to clipboard 
    Please Login or Register  to view this content.



    Regards, TMS
    had to tweak it but it worked
    thanks a lot
    Last edited by bunnyfrostr; 03-04-2014 at 04:19 PM.
    Reply With QuoteRegister To Reply
  5. 03-04-2014, 04:12 PM #5
    bunnyfrostr
    bunnyfrostr is offline
    Registered User
    Join Date
    03-03-2014
    Location
    us
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: How can I get a value to return "Y" OR "N" instead of true or false

    Quote Originally Posted by ChemistB View Post
    =IF(OR([@[First Time]]=2016, [@[2016 Sales]]>= 400000) ,"Y", "N")
    It returns back "VALUE" in all cells?
    is it something with the formula?

    you're appreciated
    Last edited by bunnyfrostr; 03-04-2014 at 04:19 PM.
    Reply With QuoteRegister To Reply
  6. 03-04-2014, 04:51 PM #6
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: How can I get a value to return "Y" OR "N" instead of true or false

    I'd need to see some sample data to understand why it is not working (Go Advanced>Manage Attachments to upload a workbook showing where the formula would go)
    It looks okay to me.
    Reply With QuoteRegister To Reply
  7. 03-04-2014, 04:57 PM #7
    bunnyfrostr
    bunnyfrostr is offline
    Registered User
    Join Date
    03-03-2014
    Location
    us
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: How can I get a value to return "Y" OR "N" instead of true or false

    Yours worked. I had to go in and tweak the other users but generally both were helpful and now I understand
    Reply With QuoteRegister To Reply
  8. 03-04-2014, 05:44 PM #8
    TMS
    TMS is online now
    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
    44,419

    Re: How can I get a value to return "Y" OR "N" instead of true or false

    What do you understand? Both solutions were identical based on your original formula. Why did you need to tweak the formula, and in what way?

    But no big deal,if you have something that works for you.



    You're welcome.
    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. compare two excel sheets using macros and display the result in "true" or "false"
    By gayunana01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 07:21 AM
  2. VLookup to return "true" or "false"
    By Sph01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2011, 11:10 AM
  3. 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
  4. 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
  5. [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