MORE THAN ONE FUNCTION IN THE SAME CELL
How I can write this function for one cell
=IF(O9<-2%;1); IF(-1%<O9<-2%;2); IF(-1%<O9<2%;3); IF(2%<O9<6%;4); IF(O96%;5)
More in detail I have to compare a value with 5 criteria and put the
relevant number from 1 to 5
Thank you
|