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?