Need Help Combining Six Formulas In One Cell

**artiststevens** · 05-18-2012, 05:27 AM

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

Please Login or Register  to view this content.

2

Please Login or Register  to view this content.

3

Please Login or Register  to view this content.

4

Please Login or Register  to view this content.

5

Please Login or Register  to view this content.

6

Please Login or Register  to view this content.

**artiststevens** · 05-18-2012, 06:55 AM

Any help would be greatly appreciated.

**wayneg** · 05-18-2012, 07:09 AM

try this

=IF(AND(MAX(C3:C9)-G2>=I2),MAX(C3:C9)-G2,IF(AND(MIN(D3:D9)-G2<=H2),MIN(D3:D9)-G2,IF(AND(MAX(C10:C17)-G2>=I2),MAX(C10:C17)-G2,IF(AND(MIN(D10:D17)-G2<=H2),(MIN(D10:D17)-G2),IF(AND(E17<F17),E17-G2)))))