Hello, I am trying to use "if" and "or" functions to select higher of lower values in a row of 40 cells. I use MAX and MIN and the mean of the row and ABS to get rid of negatives. I would like column AX to show "check" only if there is a qualifying value which is >= 0.009. It works in the AX2 but I cant work out why it is not working in AX3-5. Ideally I would like AX to show the value or the cell number of the high or low peak so that I can find it easily, any ideas?
3s for 40
|AX2:AX5||AX2||=IF(OR(AV2 > 0.009,(ABS(AW2))<0.009),"check","")|