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.5>K2<=8,"LF",IF(8>K2<=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.
Bookmarks