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.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.

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

Hi!

Try this:

=IF(K2<=4.5,"TF",IF(AND(K2>4.5,K2<=8),"LF",IF(AND(K2>8,K2<=15),"NF","AF")))

Biff

"Michael E W" <[email protected]> wrote in message
news:[email protected]...
>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.

duh!

Don't know what I was thinking!

Biff

"Biff" <[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> Try this:
>
> =IF(K2<=4.5,"TF",IF(AND(K2>4.5,K2<=8),"LF",IF(AND(K2>8,K2<=15),"NF","AF")))
>
> Biff
>
> "Michael E W" <[email protected]> wrote in message
> news:[email protected]...
>>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.
>
>