Yes, the logic is that by the time you get to the second IF you have
already tested for A1 being <=0.35, so you don't need to test for that
again, and if it is <=.7 then it must also be above 0.35.

Glad it worked for you - thanks for feeding back.

Pete

On Jul 6, 9:56 pm, mreedtigers
wrote:
Thanks for the quick help, that was much easier than I thought it would be.



"Pete_UK" wrote:
Assuming your number is in A1, then try this out in B1:

=IF(A1<=0.35,"Level I",IF(A1<=0.7,"Level II","Level III")

Hope this helps.

Pete

On Jul 6, 9:36 pm, mreedtigers
wrote:
Hey,

Please help. I'm trying to write a formula for the following:

If A <= 0.35, then "Level I" or if A 0.35 and <= 0.70, then "Level II" or
if A 0.70, then "Level III".

Can somebody help me with this?- Hide quoted text -

- Show quoted text -