|
Answer» 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.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. 6N, 7N, 8N, and 25L are the text values that are supposed to show up when the conditions are met.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")))Thank you very much. The formula worked for what I was trying to do.
|
