Help with Excel IF/THEN statement.

[smitty10492]

Here is my statement:

=IF(B207<=149,"6N/25L",IF(OR(B207>=150,B207<=199),"7N/25L",IF(B207 >=200,"8N/25L")))

What I am trying to do is:

Cell value of 149 or to less show up as 6N/25L, Cell value between 150-199 to show up as 7N/25L, Cell value of 200 or higher to show up as 8N/25L.

The statement will work for the cells values up to 199. When it reaches 200 or greater it stays at 7N/25L. 

Any ideas why the last part of this statement is not working?

Thanks.

[soybean]

Are 6N, 7N, 8N, and 25L supposed to be cell references?  If so, they are not valid; you have the numerical part and the alphabetical part of the cell reference reversed.  In other words, it should be N6, N7, etc.

[smitty10492]

 6N, 7N, 8N, and 25L are the text values that are supposed to show up when the conditions are met.

[soybean]

Well, I believe your logic got a bit convoluted, particularly with the OR statement.  Try this:

=IF(B207<=149,"6N/25L",(IF(B207<=199,"7N/25L","8N/25L")))

[smitty10492]

Thank you very much. The formula worked for what I was trying to do.