IF statement with two greater than conditions

lopeezeee

New Member
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!!
<strike>
</strike>
 

lopeezeee

New Member
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 ""
 

kweaver

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

Code:
=IF(TODAY()<G7,0,IF(TODAY()<H7,TODAY()/(H7-G7),1))
<g7,0,if(today()<h7,today() (h7-g7),1))[="" code]<g7,0,if(today()<h7,today()="" code]<="" html=""></g7,0,if(today()<h7,today()>
 
Last edited:

kweaver

Well-known Member
<g7,0,if(today()<h7,today() (h7-g7),1))[="" code]=""

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

=IF(TODAY()<g7,0,if(today()<h7,today() (h7-g7),1))


<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">start</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">end</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">6/1/2019</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8/30/2019</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">484.83333</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">I7</th><td style="text-align:left">=IF(<font color="Blue">TODAY(<font color="Red"></font>)<G7,0,IF(<font color="Red">TODAY(<font color="Green"></font>)<H7,TODAY(<font color="Green"></font>)/(<font color="Green">H7-G7</font>),1</font>)</font>)</td></tr></tbody></table></td></tr></table><br />





</g7,0,if(today()<h7,today()></g7,0,if(today()<h7,today()>
 
Last edited:

lopeezeee

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

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top