Nested "if" not returning expected value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF not working..... 5
Need Formula to "Adjust" to New Column Assignment 3
Help with nested function 10
IF AND statements 6
Nested If Question 4
Conditional formatting using If 1
simplify function 13
Stuck on Nested IF Function 2

Back
Top