Results 1 to 6 of 6

Thread: IF statement with two greater than conditions
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default IF statement with two greater than conditions

    I'm trying to display a percentage based on a State Date and End Date. For example:

    Cell G7 - 6/1/19 (Start Date)
    Cell H7 - 8/30/19 (End Date)

    With formula in I7: =IF(H7>TODAY(),(TODAY()/(H7-G7),1)

    This gives me two conditions I want if the current date exceeds the end date; however, my question lies for showing a 0% if the Start Date is greater than TODAY()

    For example,
    =IF(G7>TODAY(),0,)

    The two conflict with each other and I would like to display
    0% if the Start Date is greater than TODAY() as well as the results from this formula:
    =IF(H7>TODAY(),(TODAY()/(H7-G7),1)

    Thank you!!


  2. #2
    New Member
    Join Date
    Jun 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF statement with two greater than conditions

    And yes I have tried
    =IF(H7>TODAY(),(TODAY()/(H7-G7),1)&IF=(G7>TODAY(),0,"") which gives results in 0.2 with whatever I put as the false value in ""

  3. #3
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    398
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF statement with two greater than conditions

    Could this be it? If not, would you should some possibilities and what the results should be?

    Code:
    =IF(TODAY()
    
    Last edited by kweaver; Jun 19th, 2019 at 05:25 PM.

  4. #4
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    398
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF statement with two greater than conditions


    not sure why the full like of code didn't take in the previous message...or this one.

    =IF(TODAY()

    Excel 2010
    GHI
    6startend
    76/1/20198/30/2019484.83333

    Sheet2



    Worksheet Formulas
    CellFormula
    I7=IF(TODAY()<G7,0,IF(TODAY()<H7,TODAY()/(H7-G7),1))







    Last edited by kweaver; Jun 19th, 2019 at 05:27 PM.

  5. #5
    New Member
    Join Date
    Jun 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF statement with two greater than conditions

    Unfortunately, that did not work. The formula still sees confliction between H7>TODAY() and H7

  6. #6
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,667
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: IF statement with two greater than conditions

    not sure why the full like of code didn't take in the previous message...or this one.
    See here: https://www.mrexcel.com/forum/about-...tely-read.html
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •