IF statement with two greater than conditions

lopeezeee

New Member
Joined
Jun 19, 2019
Messages
3
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>
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

lopeezeee

New Member
Joined
Jun 19, 2019
Messages
3
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
Joined
May 8, 2018
Messages
1,039
Office Version
365, 2010
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
Joined
May 8, 2018
Messages
1,039
Office Version
365, 2010
<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
Joined
Jun 19, 2019
Messages
3
Unfortunately, that did not work. The formula still sees confliction between H7>TODAY() and H7<TODAY()
 

Watch MrExcel Video

Forum statistics

Threads
1,099,246
Messages
5,467,508
Members
406,543
Latest member
margram

This Week's Hot Topics

Top