Michael E W

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF function with 14 nested levels	Dan Fingerman	Excel Worksheet Functions	3	September 5th 05 05:57 PM
Returning expected dates	London	Excel Worksheet Functions	1	July 23rd 05 03:31 AM
Why are my nested sub-totals are displaying incorrectly?	chiefdean13	Excel Discussion (Misc queries)	1	July 20th 05 05:45 AM
Nested IF statements	John Simons	Excel Worksheet Functions	14	February 16th 05 06:17 AM
how can I exceed the nested if fuction limit	Mike	Excel Discussion (Misc queries)	0	January 30th 05 12:17 AM

All times are GMT +1. The time now is 06:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us