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?

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 <mreedtig...@discussions.microsoft.com>
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?

=IF(A5<=0.35,"Level 1",IF(A5<=0.7,"Level 2","Level3"))

Regards

Trevor


"mreedtigers" <(E-Mail Removed)> wrote in message
newsE9DC061-6699-47ED-9E50-(E-Mail Removed)...
> 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?

Try one of these:

=IF(A1<=0.35,"L1",IF(A1<=0.7,"L2","L3"))

The robust version:

=IF(ISNUMBER(A1),IF(A1<=0.35,"L1",IF(A1<=0.7,"L2","L3")),"")

--
Biff
Microsoft Excel MVP


"mreedtigers" <(E-Mail Removed)> wrote in message
newsE9DC061-6699-47ED-9E50-(E-Mail Removed)...
> 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?

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 <mreedtig...@discussions.microsoft.com>
> 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?
>
>
>

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 <mreedtig...@discussions.microsoft.com>
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 <mreedtig...@discussions.microsoft.com>
> > 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 -