+ Reply to Thread
Results 1 to 4 of 4

Need Help Please

  1. #1
    Registered User
    Join Date
    01-19-2005
    Posts
    17

    Need Help Please

    I have 2 collumns A and B. In the collums I have about 1000 cells with 6 figure numbers. I want to have a formula to tell me when the numbers in a cell in column "B"is greater than the corresponding cell in collumn "A"
    I hope I have made myself clear. Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Quote Originally Posted by John1950
    I have 2 collumns A and B. In the collums I have about 1000 cells with 6 figure numbers. I want to have a formula to tell me when the numbers in a cell in column "B"is greater than the corresponding cell in collumn "A"
    I hope I have made myself clear. Thanks in advance.
    The formula

    =B1>A1

    entered in Cell C1 (and copied down to C1000 or until your needs are met) will give you "TRUE" if B1 is greater than A1 and "FALSE" if otherwise.

    Hope this is what you need.

    Regards.
    BenjieLop
    Houston, TX

  3. #3
    Registered User
    Join Date
    01-19-2005
    Posts
    17
    Thaks Benji, That's exactly what I wanted. It worked great. Thanks again.

  4. #4
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Quote Originally Posted by John1950
    Thaks Benji, That's exactly what I wanted. It worked great. Thanks again.
    You're welcome ... thank you for the feedback.

    Regards.

+ 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