picking cells with the highest values

[schill2]

Hi, thanks for your time.

I want a formula to submit a value of...

+1 if a cell from a group of cells has one of the 3 highest values >0.6 amongst the cells AND cell B4 =True
+1 if a cell from a group of cells has one of the 3 lowest values <0.4 amongst the cells AND cell B4 =False.
-1 if a cell from a group of cells has one of the 3 lowest values <0.4 amongst the cells AND cell B4 =True.
-1 if a cell from a group of cells has one of the 3 highest values >0.6 amongst the cells AND cell B4 =True.
0 if none of the above conditions is true.

...into a cell G4. So G4 either has a value of +1 or -1 or 0.

Once again, thanks a lot for your time!

[Leonsw]

You will need a range. Expect the range to be in B4 to B10. I think the following formula will work:
=if(B4>0.6,if(B4<LARGE($B$4:$B$10,3),-1,1),if(B4<SMALL($B$4:$B$10,3),-1,1),0))

[Leonsw]

One change in the sign before SMALL.
You will need a range. Expect the range to be in B4 to B10. I think the following formula will work:
=if(B4>0.6,if(B4<LARGE($B$4:$B$10,3),-1,1),if(B4>SMALL($B$4:$B$10,3),-1,1),0))

[schill2]

Thanks Leonsw!
I'll let you know how I got on!

[schill2]

Hi again. unfortunately, I am getting a message which says "You have entered too many arguments for this function".
Do you know what else I can do?