Add to IF formula

[Toota]

I have a formula working and this is part of it
=IF(
AND(
OR(
AND(BACKLAY = "BACK", (G9 > (INDEX(Ratings,MATCH(A9,SelectionID,0))))),
G9 refers to a Market price and we "Back" when it is greater than the rating.
I would like to change the >, to another "Value %"
The value % is calculated like below
The ‘Value’ % is calculated looking at the difference in win probability based on the Analysts Ratings price v G9 market price.

This is calculated by: (1 / Ratings price) – (1 / Market price).
I would like the formula to be true only when Value % is greater than -4%
As below Picture shows No 2 would be the true Selection

Any help would be great i have been stuck on this forever
Thanks regards Toota

 

[GlennUK]

You say that you are only showing part of the formula ... why aren't you showing the full formula?

 

[Toota]

Glenn,
This is all of the formula
=IF(
AND(
OR(
AND(BACKLAY = "BACK", (G9 > (INDEX(Ratings,MATCH(A9,SelectionID,0))))),
AND(BACKLAY = "LAY", (G9 < (INDEX(Ratings,MATCH(A9,SelectionID,0)))))),
Overrounds1<UserOverround,
TimeTillJump1<UserTimeTillJump,
ISBLANK(InPlay1)),
BACKLAY,
""
)