Multiple IFs

[Guest]

I need to display the result of multiple IFs
if (J1>10<25) "1", if (j1>25<50), "2", if (j1>50), "3"-
Driving me mad...anybody help please?

 

[Chip Pearson]

Try
=IF(AND(J1>10,J1<25),"1",IF(AND(J1>25,J1<50),"2",IF(J1>50,"3"))

I

 

[Guest]

=IF(AND(J1>10;J1<25);1;IF(AND(J1>25;J1<50);2;IF(J1>50;3;"")))



"WannaM" skrev:

 

[Guest]

ups
=IF(AND(J1>10,J1<25),1,IF(AND(J1>25,J1<50),2,IF(J1>50;3,"")))



"excelent" skrev:

 

[Roger Govier]

Hi

In addition to the solutions you have, it could be achieved without IF
statements, provided you can accept 0 as the result if the value in A1
does not match any of the criteria

=(INT((A1-1)/25)+1)-(A1<10)