+ Reply to Thread
Results 1 to 9 of 9

How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

  1. #1
    Registered User
    Join Date
    12-06-2019
    Location
    Utah
    MS-Off Ver
    Office 365
    Posts
    37

    How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

    My IF/OR formula isn't working and I don't know why. If either column says TRUE in it, I want a third column to say TRUE.

    Here's my formula:
    =IF((OR(I3="TRUE",J3="TRUE")),"TRUE","FALSE")

    But it will only return FALSE even when one of the columns says TRUE.

    What am I doing wrong?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

    Try this one.

    =IF(OR(I3="TRUE",J3="TRUE"),"TRUE","FALSE")
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    12-06-2019
    Location
    Utah
    MS-Off Ver
    Office 365
    Posts
    37

    Re: How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

    That didn't work. All that was different between your formula and mine was parentheses.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

    If I3&J3 contain logical values rather than text try
    =OR(I3=TRUE,J3=TRUE)
    or simply
    =(I3+J3)>0

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

    Please show a small example of the exelfile.

    There are space before or after the word TRUE?

  6. #6
    Registered User
    Join Date
    12-06-2019
    Location
    Utah
    MS-Off Ver
    Office 365
    Posts
    37

    Re: How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

    Thank you, Fluff13!!!!! That was the trick!!!

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

    You're welcome & thanks for the feedback.

  8. #8
    Registered User
    Join Date
    12-06-2019
    Location
    Utah
    MS-Off Ver
    Office 365
    Posts
    37

    Re: How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

    Hey - just noticed one small problem. Any idea why this formula returns TRUE when both columns say FALSE?

  9. #9
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: How do I formulate: If A is TRUE or if B is TRUE, then C is TRUE?

    Can you supply a sample workbook?

+ 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. Replies: 6
    Last Post: 03-17-2019, 02:20 PM
  2. Replies: 3
    Last Post: 08-16-2018, 06:07 AM
  3. =AND() not working as expected. Two true functions don't give true result
    By rectorsquid in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-30-2018, 04:34 PM
  4. [SOLVED] .Visible property not remaining true (or even becoming true) when code runs.
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2015, 06:20 PM
  5. Help popup window if condition is TRUE in change event if conditon is true
    By fanku in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-09-2014, 12:46 PM
  6. how to make checkbox true selecting then chaning 2nd box true when null
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2012, 01:13 PM
  7. [SOLVED] 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

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