I'd like to make a Pass/Fail statement based upon whether or not a range of cells contain any number above 1 or below -1. If the values are outside that range I'd like the cell to display Fail, if the values are withing the range I'd like the cell to display Pass.
I know the formula isn't correct, but I was trying to go in this direction:
=IF('Participant 1'!I11:I16<-1,"Fail",IF('Participant 1'!I11:I20>1,"Fail","Pass"))
I would appreciate any help. Thank you.
I know the formula isn't correct, but I was trying to go in this direction:
=IF('Participant 1'!I11:I16<-1,"Fail",IF('Participant 1'!I11:I20>1,"Fail","Pass"))
I would appreciate any help. Thank you.