Nested "if" not returning expected value
I think I followed the directives of the "help" instructions but it's not
working and I'm not seeing it. The Formula is as follows: =IF(K2<=4.5,"TF",IF(4.5K2<=8,"LF",IF(8K2<=15,"NF ","AF"))) The result is always "AF" if the value in K2 is 4.5 and I think this is the exact layout the help center gives. A review from talented eyes would be appreciated. |
I figured it out but thanks anyway. I got rid of X<K2<Y. All I needed was the
Y so it could keep on going down the list. As usual, the problem in the operator. "Michael E W" wrote: I think I followed the directives of the "help" instructions but it's not working and I'm not seeing it. The Formula is as follows: =IF(K2<=4.5,"TF",IF(4.5K2<=8,"LF",IF(8K2<=15,"NF ","AF"))) The result is always "AF" if the value in K2 is 4.5 and I think this is the exact layout the help center gives. A review from talented eyes would be appreciated. |
Does this work for you?
=IF(K2<=4.5,"TF",IF(K2<=8,"LF",IF(K2<=15,"NF","AF" ))) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Michael E W" wrote in message ... I think I followed the directives of the "help" instructions but it's not working and I'm not seeing it. The Formula is as follows: =IF(K2<=4.5,"TF",IF(4.5K2<=8,"LF",IF(8K2<=15,"NF ","AF"))) The result is always "AF" if the value in K2 is 4.5 and I think this is the exact layout the help center gives. A review from talented eyes would be appreciated. |
Hi!
Try this: =IF(K2<=4.5,"TF",IF(AND(K24.5,K2<=8),"LF",IF(AND( K28,K2<=15),"NF","AF"))) Biff "Michael E W" wrote in message ... I think I followed the directives of the "help" instructions but it's not working and I'm not seeing it. The Formula is as follows: =IF(K2<=4.5,"TF",IF(4.5K2<=8,"LF",IF(8K2<=15,"NF ","AF"))) The result is always "AF" if the value in K2 is 4.5 and I think this is the exact layout the help center gives. A review from talented eyes would be appreciated. |
duh!
Don't know what I was thinking! Biff "Biff" wrote in message ... Hi! Try this: =IF(K2<=4.5,"TF",IF(AND(K24.5,K2<=8),"LF",IF(AND( K28,K2<=15),"NF","AF"))) Biff "Michael E W" wrote in message ... I think I followed the directives of the "help" instructions but it's not working and I'm not seeing it. The Formula is as follows: =IF(K2<=4.5,"TF",IF(4.5K2<=8,"LF",IF(8K2<=15,"NF ","AF"))) The result is always "AF" if the value in K2 is 4.5 and I think this is the exact layout the help center gives. A review from talented eyes would be appreciated. |
All times are GMT +1. The time now is 08:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com