IF statement with two greater than conditions

[lopeezeee]

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]

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]

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

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

 

[kweaver]

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

Excel 2010
	G	H	I
6	start	end
7	6/1/2019	8/30/2019	484.83333
Sheet2

Cell Formulas
Range	Formula
I7	=IF(TODAY()TODAY())/(H7-G7),1))

</g7,0,if(today()<h7,today()></g7,0,if(today()<h7,today()>

 

[lopeezeee]

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

 

[Joe4]

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-board/680917-formulas-not-appearing-completely-read.html