Multiple IFs
 

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

Multiple IFs
 

Try
=IF(AND(J110,J1<25),"1",IF(AND(J125,J1<50),"2",I F(J150,"3"))

I

"WannaM" wrote in message
...
I need to display the result of multiple IFs
if (J110<25) "1", if (j125<50), "2", if (j150), "3"-
Driving me mad...anybody help please?

Multiple IFs
 

=IF(AND(J110;J1<25);1;IF(AND(J125;J1<50);2;IF(J1 50;3;"")))



"WannaM" skrev:

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

Multiple IFs
 

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



"excelent" skrev:

=IF(AND(J110;J1<25);1;IF(AND(J125;J1<50);2;IF(J1 50;3;"")))



"WannaM" skrev:

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

Multiple IFs
 

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)

--
Regards

Roger Govier


"WannaM" wrote in message
...
I need to display the result of multiple IFs
if (J110<25) "1", if (j125<50), "2", if (j150), "3"-
Driving me mad...anybody help please?