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
wrote in message
...
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