Multiple IFs

W

WannaM

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?
 
E

excelent

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



"excelent" skrev:
 
R

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)
 
Top