+ Reply to Thread
Results 1 to 2 of 2

Return False or True with condition

  1. #1
    Registered User
    Join Date
    02-12-2019
    Location
    paris
    MS-Off Ver
    2018
    Posts
    1

    Return False or True with condition

    Hi im new in this Forum, Hello for all

    I have a list of I to IIII in cell A1 is class
    and for each number from I to IIII receives true or false in the table

    I want IF I put it for example from the list "I" and in the table "I" receives "False" so in cell C2 "Not validated" and if true in cell C2 "Valid"
    the some for each number of the list

    thank you
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 02-12-2019 at 09:26 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,280

    Re: Return False or True with condition

    welcome to the forum

    For future reference, please take a moment to read the forum rules and use thread titles that are descriptive of your problem - not what you think the answer might be. (think google search terms?).

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    I changed it for you this time as you are a new member
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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