Posted to microsoft.public.excel.misc

external usenet poster

Posts: 14

Limit on logical function

I need to add 5 more conditions to my statement below. I have tried and I
can only enter 3 more before I get an error. Does anyone have any
suggestions for a work around or a better way to enter the formula?

=IF(AND(AH8<=10000,AH80),5,IF(AND(AH8=10001,AH8< =25000),4,IF(AND(AH8=25001,AH8<=50000),3,IF(AND(A H8=50001,AH8<=100000),2,IF(AND(AH8=0),0,1)))))
--
AJ

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
logical function bug?	rgs	Excel Worksheet Functions	4	April 28th 08 10:20 PM
Help with logical function	PT	New Users to Excel	2	February 22nd 08 02:13 AM
Help with logical function	PT	Excel Worksheet Functions	2	February 22nd 08 02:13 AM
should it be if() or another logical function?	Gina	Excel Worksheet Functions	2	November 10th 06 05:59 PM
logical function	[email protected]	Excel Worksheet Functions	4	July 27th 06 04:43 AM

All times are GMT +1. The time now is 12:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us