Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF function with 14 nested levels | Excel Worksheet Functions | |||
Returning expected dates | Excel Worksheet Functions | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
how can I exceed the nested if fuction limit | Excel Discussion (Misc queries) |