Need Help Fixing A Nested Formula

I need help reformulating this nesting formula.

I want the portion of the formula to be where IF I6=1 and C7, D7, E7 are greater than F7 then the result is true then it equals (1) if false it equals (-1).

I want the portion of the formula to be where IF I6=-1 and C7, D7, E7 are less than F7 then the result is true then it equals (-1) if false it equals (1).

I think I may be missing a parentheses somewhere.

Please Login or Register  to view this content.

Please see the attached worksheet for more information. The yellow highlighted areas in column [I] are where result is wrong.


Thanking you in advance for any and all help.

Sorry wrong answer...

Like this Stevens?

Formula:

Please Login or Register  to view this content.

I was wright with my answer
=IF(I6=1,IF(AND(C7>F7,D7>F7,E7>F7),1,-1),IF(I6=-1,IF(AND(C7<F7,D7<F7,E7<F7),-1,1)))
Some of you expected result are wrong
Let say row 10 can not be -1 when I9 is -1 as F10 is greater than D10 adn E10

You are welcome and thanks for the feedback & rep*.

Happy New Year!