# 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))

</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()