Posted to microsoft.public.excel.programming

newby1273

external usenet poster

Posts: 5

Too many nested functions problem

I need to do this
=IF(IFH6=0,0,(H6<=13,13.1,IF(H6<=32,14.13,IF(H6<=5 2,14.99,IF(H6<=70,16.16,IF(H6<=90,16.74,IF(H6<=100 ,19.67,IF(H6<=200,39.34,IF(H6<=300,59.01,FALSE)))) )))))
but since it's more than 7 nested functions excel won't allow it. How can I
make this work?

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
Nested IF & AND functions	Stana1027	Excel Worksheet Functions	4	April 27th 10 06:23 AM
Nested IF functions	is2cu	Excel Worksheet Functions	2	November 19th 09 08:47 PM
Nested functions	Joyce	Excel Discussion (Misc queries)	4	January 18th 08 07:04 PM
Nested Functions	Toppers	Excel Discussion (Misc queries)	0	February 22nd 07 07:37 PM
nested if(and) functions	Rohan	Excel Discussion (Misc queries)	3	August 12th 05 01:30 AM

All times are GMT +1. The time now is 03:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us