+ Reply to Thread
Results 1 to 2 of 2

Comparing 2 cells and putting the results of a 3 cell.

  1. #1
    Forum Contributor
    Join Date
    12-03-2009
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    184

    Comparing 2 cells and putting the results of a 3 cell.

    Hi all,

    I'm comparing cell3 for <= of cell4 if true then the value of cell1 goes into cell2.

    The formula below is what I have in cell2. Cells 1,3&4 have data that is being pulled from another worksheet and I'm wondering if that's why it's not working. The results always come back blank even tho I can see some of them are true. Any help is appreciated.

    placed in cell2

    =if($L4<=$N4,$F4,"")

    =if(cell3<=cell4,cell1,"")

    Thanks
    E.
    Last edited by enhydra; 05-08-2022 at 09:24 PM.

  2. #2
    Forum Contributor
    Join Date
    12-03-2009
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    184

    Re: Comparing 2 cells and putting the results of a 3 cell.

    Never mind, I was selecting the wrong cell

+ 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] Putting Results of two cells in one cell with correct formating
    By heresteve2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2015, 01:05 PM
  2. [SOLVED] Comparing Cells from different spreadsheets with each other and giving different results
    By MartinMuster in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-01-2014, 09:36 AM
  3. Trying to display results after comparing 2 cells on different sheets
    By Lylebrous in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2014, 06:22 PM
  4. Putting the results of a vlookup into a cell's comment
    By trishcollins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2014, 04:38 PM
  5. Comparing Multiple Cells in different rows and copying results
    By Eric@Gopher in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-10-2012, 05:46 PM
  6. Replies: 1
    Last Post: 02-14-2012, 05:45 PM
  7. Excel 2007 : Comparing cells to find best results
    By berk21 in forum Excel General
    Replies: 7
    Last Post: 11-04-2009, 06:46 PM

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