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!
Bookmarks