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

1. ## 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. ## 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. ## 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()
```

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

5. ## Re: IF statement with two greater than conditions

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

6. ## 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.