conditional formula in Excel
 

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?

conditional formula in Excel
 

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?

conditional formula in Excel
 

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

Regards

Trevor


"mreedtigers" wrote in message
...
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?

conditional formula in Excel
 

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" wrote in message
...
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?

conditional formula in Excel
 

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?

conditional formula in Excel
 

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 -