Need Help Combining Six Formulas In One Cell

Hello,
I need help combining six formulas so that they are contained in one cell. The six formulas can be found below. I would like the result of formula one to take precedence over formula two and so on. I also attached a spread sheet with the formulas in it and it explains in better detail what I'm looking for. Thanking you in advance for any and all help.

1

=(IF(AND(MAX(C3:C9)-G2>=I2),MAX(C3:C9)-G2))

2

=(IF(AND(MIN(D3:D9)-G2<=H2),(MIN(D3:D9)-G2)))

3

=(IF(AND(E9<=F9),E9-G2))

4

=(IF(AND(MAX(C10:C17)-G2>=I2),MAX(C10:C17)-G2))

5

=(IF(AND(MIN(D10:D17)-G2<=H2),(MIN(D10:D17)-G2)))

6

=(IF(AND(E17<F17),E17-G2))