IF Nested Statement

[jwoolsey08]

[FONT=&quot]

I am trying to create an IF nested statement. Having issues connecting them. Anything smaller than or equal to the value 0.4 should be designated the value of “VL” (very low), anything smaller than or equal to 2.1 should be “L” (low), anything smaller than 11.4 should be H (High). Any value greater than 11.4 should be "VH" very high. The valid values are VL, L, H and VH. I have come up with the statements, but cannot connect them. Any help would be appreciated.

Thank you,[/FONT][FONT=&quot]<o></o>[/FONT]
[FONT=&quot]
John W<o></o>[/FONT]

 

[Jonmo1]

Welcome to the board...

Try LOOKUP instead....

=LOOKUP(A1,{0,0.5,2.2,11.5},"VL","L","H","VH"})

 

[T. Valko]

[FONT=&quot]I am trying to create an IF nested statement. Having issues connecting them. Anything smaller than or equal to the value 0.4 should be designated the value of “VL” (very low), anything smaller than or equal to 2.1 should be “L” (low), anything smaller than 11.4 should be H (High). Any value greater than 11.4 should be "VH" very high. The valid values are VL, L, H and VH. I have come up with the statements, but cannot connect them. Any help would be appreciated. [/FONT]

[FONT=&quot]Thank you,[/FONT][FONT=&quot]<?xml:namespace prefix = o /><o></o>[/FONT]

[FONT=&quot]John W<o></o>[/FONT]

Maybe this...

=IF(A1="","",IF(A1>11.4,"VH",IF(A1>2.1,"H",IF(A1>0.4,"L","VL"))))

 

[jwoolsey08]

It's for an excel class, professor wants us to develop our IF statements. This is what I've come up with. I'm not sure what I am doing wrong.

=IF(E3>=11.4,"VH","H")=IF(E3<=2.1,"VL","L")=IF(E3<=0.4,"VL")

 

[T. Valko]

It's for an excel class, professor wants us to develop our IF statements. This is what I've come up with. I'm not sure what I am doing wrong.

=IF(E3>=11.4,"VH","H")=IF(E3<=2.1,"VL","L")=IF(E3<=0.4,"VL")

Well, one thing you need to do is better define the intervals.

Here's what you want:

<=0.4
<=2.1
<11.4
>11.4

What if it =11.4?

Also, it would be good to know if <=0.4 means the numbers could be negative or does the scale start at 0?

 

[jwoolsey08]

Thanks T Valko! I appreciate it!

http://www.mrexcel.com/forum/member.php?u=117397

 

[T. Valko]

Thanks T Valko! I appreciate it!

You're welcome. Thanks for the feedback!