+ Reply to Thread
Results 1 to 3 of 3

Reversing True to False

  1. #1
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Question Reversing True to False

    Is there a function or value I can apply to another function to reverse the True/False value?

    ISNUMBER(SEARCH(1,1)) = TRUE, but I want to know =ISNOTANUMBER(SEARCH(1,1)) = TRUE.

    I'm looking for ways narrow a range a range such as using SUMIF(range1=a1,if(range2=/=number,etc))

    I've tried ISTEXT, ISNONTEXT, ISNUMBER, ISERR, ISNA, but am having trouble coming up with the correct statement.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Reversing True to False

    Maybe

    NOT(ISNUMBER(SEARCH(1,1))) ?

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Reversing True to False

    NOT.

    Today, I was a fool.

+ 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] Search for 2 true arguments and return true or false
    By David in forum Excel General
    Replies: 3
    Last Post: 07-15-2006, 05:20 AM
  2. Function to return True/False if all are validated as True by ISNU
    By Tetsuya Oguma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 06:30 AM
  3. Reverse false and combine with true true value
    By DaveB in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 09-06-2005, 07:05 PM
  4. Reverse false and combine with true true value
    By Emmie99 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  5. Reverse false and combine with true true value
    By DaveB in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 04:05 AM

Tags for this Thread

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