You need to use some ANDs.

=IF(A1<0.3,1,IF(AND(A10.3,A1<1.6),2,IF(AND(A11.6 ,A1<3.1),3,"etc.")))

As long as you're not nesting more than 7 IFs, then this should work.

HTH,
Paul

--

"sadata" wrote in message
...
I have a list of parameters I want 1 cell to calculate: e.g.
=IF(A1<0.3),1,IF(A10.3,A1<1.6),2,IF(A11.6,A1<3.1 ),3,....ETC. I KEEP
GETTING AN ERROR MESSAGE...IS THERE SOMETHING I AM MISSING?