+ Reply to Thread
Results 1 to 5 of 5

if cell is higher then, but if not

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    if cell is higher then, but if not

    hi guys

    i am absolutely useless with formulas

    how can i write if cell DT2 is higher than cell EO2 then return the answer from L2 but if EO2 is higher than DT2 then return the answer from T2

    thank you

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,733

    Re: if cell is higher then, but if not

    Try this:

    =IF(DT2>EO2,L2,IF(EO2>DT2,T2,"what if draw?"))

    You need to specify what to do if the two cells are equal, i.e. change "what if draw?" to what you want in that case.

    Hope this helps.

    Pete

  3. #3
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: if cell is higher then, but if not

    Thanks pete
    as superb as ever
    much appreciated

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: if cell is higher then, but if not

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    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


  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: if cell is higher then, but if not

    You're welcome. Thanks for the rep.

    Pete's solution was much more comprehensive

+ 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. count cells that have a higher value than the cell above it in a row
    By umavaidya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2016, 03:02 AM
  2. Replies: 2
    Last Post: 09-23-2013, 01:09 AM
  3. Highlighting the Higher Cell in a Row
    By mavendark in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-02-2012, 04:45 AM
  4. Replies: 2
    Last Post: 05-31-2010, 03:23 PM
  5. delete row is if a cell value is higher than...
    By barkiny in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2006, 02:40 PM
  6. comparing a value in a cell to see if it is higher than a number
    By PK in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-05-2005, 11:05 PM
  7. Configuring a cell to take higher values only
    By hdhuri40 in forum Excel General
    Replies: 5
    Last Post: 05-25-2005, 04:53 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