MORE THAN ONE FUNCTION IN THE SAME CELL

[Papadopoulos Panagiotis]

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(O9>6%;5)

More in detail I have to compare a value with 5 criteria and put the
relevant number from 1 to 5

Thank you

 

[Guest]

Hi

Something like this should do the trick:
=IF(O9<-0.02,1,IF(O9<-0.01,2,IF(O9<2,3,IF(O9<0.06,4,5))))

Andy.

"Papadopoulos Panagiotis" <Papadopoulos
[email protected]> wrote in message
news:[email protected]...