+ Reply to Thread
Results 1 to 6 of 6

IF Cell is Greater than Range Equal 1 or 0 HELP

  1. #1
    Registered User
    Join Date
    07-31-2019
    Location
    US
    MS-Off Ver
    2016
    Posts
    3

    IF Cell is Greater than Range Equal 1 or 0 HELP

    Hello All,

    I am trying to have a cell do the following logic.

    IF cell(P25) is greater than cells Q25:Z25 then 1, if false = 0.

    Where is what I have tried with no luck:

    =IF(P25>($Q$25,$R$25,$S$25,$T$25,$U$25,$V$25,$W$25,$X$25,$Y$25,$Z$25),1,0)

    =IF(P25>(Q25:Z25),1,0)

    I keep getting the #VALUE in the cell where I want the formula.

    I don't think it can process the range of cells.

    Ideas?

  2. #2
    Registered User
    Join Date
    07-31-2019
    Location
    US
    MS-Off Ver
    2016
    Posts
    3

    Re: IF Cell is Greater than Range Equal 1 or 0 HELP

    I was able to come up with this. Its very messy but it works! Any way I can trim it down?

    =IF(P25>Q25,1,0)*(AND(IF(P25>R25,1,0)))*(AND(IF(P25>S25,1,0)))*(AND(IF(P25>T25,1,0)))*(AND(IF(P25>U25,1,0)))*(AND(IF(P25>V25,1,0)))*(AND(IF(P25>W25,1,0)))*(AND(IF(P25>X25,1,0)))*(AND(IF(P25>Y25,1,0)))*(AND(IF(P25>Z25,1,0)))

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: IF Cell is Greater than Range Equal 1 or 0 HELP

    How about this?
    =IF(P25>max(Q25:Z25),1,0)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: IF Cell is Greater than Range Equal 1 or 0 HELP

    hmm or maybe even...
    =--(P25>max(Q25:Z25))

  5. #5
    Registered User
    Join Date
    07-31-2019
    Location
    US
    MS-Off Ver
    2016
    Posts
    3

    Re: IF Cell is Greater than Range Equal 1 or 0 HELP

    The first one worked beautifully! I WAS playing with MAX as I do have it in another formula for Games Back, but I seemed to have had it in the incorrect spot. This is great! Thank you!

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: IF Cell is Greater than Range Equal 1 or 0 HELP

    Happy to help

+ 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. Replies: 4
    Last Post: 05-11-2018, 09:53 AM
  2. [SOLVED] Advanced Filter - Greater than or equal to another cell?
    By PaddyP in forum Excel General
    Replies: 3
    Last Post: 12-13-2017, 03:13 PM
  3. If cell value is less than or equal to, OR greater than or equal to
    By Pacific_Quest in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-07-2017, 11:20 AM
  4. Change cell value to zero if greater than or equal to one in a range
    By ExelDummy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2015, 04:23 PM
  5. [SOLVED] COUNTIFS function w/greater than or equal to, and less than or equal to time values
    By AliciaRenee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 03:57 PM
  6. [SOLVED] Conditional formatting if equal or greater than average in the range of cells
    By Abu Abdurakhim in forum Excel General
    Replies: 7
    Last Post: 05-28-2013, 10:01 AM
  7. [SOLVED] if cell value is greater than or equal to 2 change its value to 1
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-25-2012, 03:03 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