IF / AND Statement

[bickersc]

I am trying to write a statement in regards to if a part is less than 36" to use (PART #), if part is greater than 36" & less than 48" to use (PART #), if part is greater than 48" to use (PART #).
I currently have tried this statement: =IF(L17<36,"8092SB EB 36",IF(AND(L17>36,L2<48,L2,"8092SB EB 48",IF(L2>48,"8092SB EB 72")))) but I keep getting an error and I can not figure out the problem nor a solution.

Any help would be appreciated.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(L17<36,"8092SB EB 36",IF(L17<48,"8092SB EB 48","8092SB EB 72"))

 

[dreid1011]

And just to show you where the issue with your current formula is:

=IF(L17<36,"8092SB EB 36",IF(AND(L17>36,L2<48,L2,"8092SB EB 48",IF(L2>48,"8092SB EB 72"))))

should be

=IF(L17<36,"8092SB EB 36",IF(AND(L17>36,L2<48),"8092SB EB 48",IF(L2>48,"8092SB EB 72","")))

Though I am not sure why you are using both L17 and L2 in the comparison. Seems to give inaccurate results.

 

[NateSC]

Just as a side note, consider if the part is 36" or 48". Your equation, when working per @dreid1011 's corrections, will ignore parts that are those exact lengths. If it is possible to have those lengths, then you may need to change some of the operators to "<=" or ">=".

In @Fluff 's simplification, if the part is 36", it will fall in with parts that are <48". Just make sure everything is falling into the correct buckets.

 

[bickersc]

And just to show you where the issue with your current formula is:

=IF(L17<36,"8092SB EB 36",IF(AND(L17>36,L2<48,L2,"8092SB EB 48",IF(L2>48,"8092SB EB 72"))))

should be

=IF(L17<36,"8092SB EB 36",IF(AND(L17>36,L2<48),"8092SB EB 48",IF(L2>48,"8092SB EB 72","")))

Though I am not sure why you are using both L17 and L2 in the comparison. Seems to give inaccurate results.

Boom, perfect, thank you so much......yes I missed the L2's which should have been L17's