MORE THAN ONE FUNCTION IN THE SAME CELL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Papadopoulos Panagiotis - 20 Mar 2006 17:49 GMT

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

Reply to this Message

Andy - 20 Mar 2006 18:01 GMT

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.

> 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);
[quoted text clipped - 4 lines]
>
> Thank you

Reply to this Message