+ Reply to Thread
Results 1 to 8 of 8

formula if condition match then true else false

  1. #1
    Forum Contributor
    Join Date
    06-09-2014
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    formula if condition match then true else false

    Hi Experts
    I am looking for a formula that will give me the result as true or false, If condition met
    Plz see the sample file
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,769

    Re: formula if condition match then true else false

    Maybe
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copied down
    Trevor Shuttleworth - Excel Aid

    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


  3. #3
    Forum Contributor
    Join Date
    06-09-2014
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: formula if condition match then true else false

    Sorry TMS Sir but after putting formula i am not getting the desired output
    plz put the formula in the sample file and see the output

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,235

    Re: formula if condition match then true else false

    Try:

    =OR(INT(A1)=INT(B1),INT(A1)=INT(C1))

  5. #5
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,247

    Re: formula if condition match then true else false

    You don't say so anywhere but it looks like you are comparing just the integer part for testing equality, not any fractional part. There is not enough sample data to determine whether I should be truncating to integer or rounding, but the following mod or TMS's formula works with your 3 test cases:

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

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select “Solved” from the Thread Tools menu

  6. #6
    Forum Contributor
    Join Date
    06-09-2014
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: formula if condition match then true else false

    Problem Solved
    Thnx Alot TMS, Bebo021999, GeoffW283 for helping me in solving this problem Sir
    Have a Awesome Day

  7. #7
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,247

    Re: formula if condition match then true else false

    Have a Awesome Day
    You too. Thanks for the feedback.

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,769

    Re: formula if condition match then true else false

    You're welcome. Thanks for the rep.

+ 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. Return False or True with condition
    By stev_2109 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2019, 09:26 AM
  2. [SOLVED] Formula to skip cell if condition is true/false
    By tjb0012 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-13-2018, 02:45 PM
  3. [SOLVED] Match formula to search range of columns to return True or False result
    By Twaddy006 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2015, 05:42 PM
  4. [SOLVED] Index Match formula with Or Exact True/False output
    By Karroog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-10-2014, 02:32 PM
  5. If True/False Condition
    By Hallet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-04-2012, 05:18 PM
  6. Condition code True False on Checkbox
    By RobertCo in forum Excel General
    Replies: 2
    Last Post: 12-16-2006, 07:47 AM
  7. Replies: 3
    Last Post: 03-06-2005, 12:00 PM

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