+ Reply to Thread
Results 1 to 4 of 4

Formula that produces True or False results

  1. #1
    Registered User
    Join Date
    08-30-2020
    Location
    Texas
    MS-Off Ver
    365
    Posts
    16

    Formula that produces True or False results

    I need a formula to help me find "True/False" results based on 2 columns.

    1) First column has the Tag # (these can appear more than twice)
    2) Second column has the price (these can be different, but the 1st price is always right)
    3) 90% of time the tag #'s will have the same price, but there is occasions when the price is different for the same tag #.

    In that case, I want to find the instances that are different using a formula that will give me a "TRUE" or "FALSE" result (or whatever works best)
    My example below illustrates column A (tag #) and column B (price) and column C (what the formula should produce)
    Please note that the price on the 1st one will always be right.


    TAG # $-PRICE FORMULA

    123456 $35 SHOULD BE TRUE
    123456 $35 SHOULD BE TRUE
    123456 $45 SHOULD BE FALSE
    123456 $85 SHOULD BE FALSE

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,784

    Re: Formula that produces True or False results

    Put in the first row and copy down. This checks to see if each occurrence of a price for a tag number matches the first price listed for that tag number.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    08-30-2020
    Location
    Texas
    MS-Off Ver
    365
    Posts
    16

    Re: Formula that produces True or False results

    This worked perfectly! Thank you so much Jeff!

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,784

    Re: Formula that produces True or False results

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

+ 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] Formula Results as False when True
    By tjb1122 in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 12-16-2020, 12:08 PM
  2. [SOLVED] IF formula using other cell values as true/false results
    By kschmit1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2017, 08:22 AM
  3. [SOLVED] want results as true or false
    By abubaniyan in forum Excel General
    Replies: 3
    Last Post: 12-10-2014, 06:33 AM
  4. Countifs Formula that show True/False results?
    By Kid Wonder in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-12-2013, 12:57 PM
  5. [SOLVED] I Need Help Creating a Formula to That Sorts True/False Results
    By artiststevens in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-09-2013, 07:38 AM
  6. Replies: 14
    Last Post: 06-27-2012, 04:26 PM
  7. Formula that will give me True or False results
    By Reenee in forum Excel General
    Replies: 2
    Last Post: 02-02-2009, 10:36 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