I know You cannot enter, or nest, no more than seven levels of functions
within a function. I need 8, is there any possible solution to get 8?

Thanks

You could create a user defined function. You should be able to find more
info here

http://www.ozgrid.com/VBA/Functions.htm


"billy boy" wrote:

I know You cannot enter, or nest, no more than seven levels of functions
within a function. I need 8, is there any possible solution to get 8?

Thanks

Yes...post you need
--
Gary''s Student - gsnu200713

More than likely. If you post details, I (or someone else) may be able to be
of assistance. Otherwise, "probably" is about the best you're going to get
out of me.

Some discussion here - post back w/details if it does not help you.
http://cpearson.com/excel/nested.htm



"billy boy" wrote:

I know You cannot enter, or nest, no more than seven levels of functions
within a function. I need 8, is there any possible solution to get 8?

Thanks

Here is what I have

=IF(AND(E591000,E5<99000),"1-50 &
1-40",IF(AND(E5139600,E5<147000),"4-40's",IF(AND(E5182000,E5<198000),"2-40's
&
2-50's",IF(AND(E5176501,E5<181999),"3-50s",IF(AND(E5161000,E5<167500),"3-40's
& 1-50",IF(AND(E5167501,E5<176500),"3-40's & 1-50 OR
3-50's",IF(AND(E5147001,E5<154500),"4-40's OR 1-40 & 2-50's","No good")))

This is what I want

=IF(AND(E591000,E5<99000),"1-50 &
1-40",IF(AND(E5139600,E5<147000),"4-40's",IF(AND(E5182000,E5<198000),"2-40's
&
2-50's",IF(AND(E5176501,E5<181999),"3-50s",IF(AND(E5161000,E5<167500),"3-40's
& 1-50",IF(AND(E5167501,E5<176500),"3-40's & 1-50 OR
3-50's",IF(AND(E5147001,E5<154500),"4-40's OR 1-40 &
2-50's",IF(AND(E5182000,E5<195000),"3-50's,","No good"))))))))

Thanks






"Gary''s Student" wrote:

Yes...post you need
--
Gary''s Student - gsnu200713

Yes - buy Excel 2007.

--

JoAnn Paules
Microsoft MVP - Publisher

How to ask a question
http://support.microsoft.com/kb/555375



"billy boy" wrote in message
...
I know You cannot enter, or nest, no more than seven levels of functions
within a function. I need 8, is there any possible solution to get 8?

Thanks

On Mon, 2 Apr 2007 17:38:03 -0700, billy boy
wrote:

Here is what I have

=IF(AND(E591000,E5<99000),"1-50 &
1-40",IF(AND(E5139600,E5<147000),"4-40's",IF(AND(E5182000,E5<198000),"2-40's
&
2-50's",IF(AND(E5176501,E5<181999),"3-50’s",IF(AND(E5161000,E5<167500),"3-40's
& 1-50",IF(AND(E5167501,E5<176500),"3-40's & 1-50 OR
3-50's",IF(AND(E5147001,E5<154500),"4-40's OR 1-40 & 2-50's","No good")))

This is what I want

=IF(AND(E591000,E5<99000),"1-50 &
1-40",IF(AND(E5139600,E5<147000),"4-40's",IF(AND(E5182000,E5<198000),"2-40's
&
2-50's",IF(AND(E5176501,E5<181999),"3-50’s",IF(AND(E5161000,E5<167500),"3-40's
& 1-50",IF(AND(E5167501,E5<176500),"3-40's & 1-50 OR
3-50's",IF(AND(E5147001,E5<154500),"4-40's OR 1-40 &
2-50's",IF(AND(E5182000,E5<195000),"3-50's,","No good"))))))))

Thanks



VLOOKUP would be a much simpler construct.

It would also let you more easily see that you have some overlapping ranges. In
your desired formula, you have the following:

....IF(AND(E5182000,E5<198000),"2-40's & 2-50's" ...
....IF(AND(E5182000,E5<195000),"3-50's," ...



You could set up a table like:

0 No Good
91,000 1-50 & 1-40
99,001 No Good
139,600 4-40's
147,001 4-40's OR 1-40 & 2-50's
154,501 No Good
161,000 3-40's & 1-50
167,501 3-40's & 1-50 OR 3-50's
176,501 3-50's
182,000 2-40's & 2-50's
182,000 3-50's


But you'd have to figure out what you want to do at the end where you have
overlapping ranges.

And then use a formula like:

=VLOOKUP(E5,tbl,2)


--ron

bit of a sledgehammer no?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JoAnn Paules" wrote in message
...
Yes - buy Excel 2007.

--

JoAnn Paules
Microsoft MVP - Publisher

How to ask a question
http://support.microsoft.com/kb/555375



"billy boy" wrote in message
...
I know You cannot enter, or nest, no more than seven levels of functions
within a function. I need 8, is there any possible solution to get 8?

Thanks

Appears to me that "LOOKUP" could be used, with "No Good" being returned
for the "gaps" in the sequence.

billy boy wrote:

Here is what I have

=IF(AND(E591000,E5<99000),"1-50 &
1-40",IF(AND(E5139600,E5<147000),"4-40's",IF(AND(E5182000,E5<198000),"2-40's
&
2-50's",IF(AND(E5176501,E5<181999),"3-50s",IF(AND(E5161000,E5<167500),"3-40's
& 1-50",IF(AND(E5167501,E5<176500),"3-40's & 1-50 OR
3-50's",IF(AND(E5147001,E5<154500),"4-40's OR 1-40 & 2-50's","No good")))

This is what I want

=IF(AND(E591000,E5<99000),"1-50 &
1-40",IF(AND(E5139600,E5<147000),"4-40's",IF(AND(E5182000,E5<198000),"2-40's
&
2-50's",IF(AND(E5176501,E5<181999),"3-50s",IF(AND(E5161000,E5<167500),"3-40's
& 1-50",IF(AND(E5167501,E5<176500),"3-40's & 1-50 OR
3-50's",IF(AND(E5147001,E5<154500),"4-40's OR 1-40 &
2-50's",IF(AND(E5182000,E5<195000),"3-50's,","No good"))))))))

Thanks






"Gary''s Student" wrote:


Yes...post you need
--
Gary''s Student - gsnu200713