Limits on nested formulas
 

I am working on a nested formula and if I put more than 7 formulas I get as
message that I have to many formulas, yet according to Excel 2007 help I
should be able to nest 64 formulas. Am i reading that wrong or is something
else going on?
--
Jerry Edge

Limits on nested formulas
 

May be you are working on a file created in 2003 format - xls extension.

Save it as an xlsx file then you will get the increased numbers of If

"Jerry Edge" wrote:

I am working on a nested formula and if I put more than 7 formulas I get as
message that I have to many formulas, yet according to Excel 2007 help I
should be able to nest 64 formulas. Am i reading that wrong or is something
else going on?
--
Jerry Edge

Limits on nested formulas
 

I have tried in xlsx, xlsm and xlsb and they all give me the same message. I
also get a message that the following feature cannot be saved in macro-free
workbook .VB project. It will not let me save it with a macro
--
Jerry Edge


"Sheeloo" wrote:

May be you are working on a file created in 2003 format - xls extension.

Save it as an xlsx file then you will get the increased numbers of If

"Jerry Edge" wrote:

I am working on a nested formula and if I put more than 7 formulas I get as
message that I have to many formulas, yet according to Excel 2007 help I
should be able to nest 64 formulas. Am i reading that wrong or is something
else going on?
--
Jerry Edge

Limits on nested formulas
 

I tested with the following;
=IF(A1<10,IF(A1<9,IF(A1<8,IF(A1<7,IF(A1<6,IF(A1<5, IF(A1<4,IF(A1<3,IF(A1<2,"<=1","=2"),"=3"),"=4") ,"=5"),"=6"),"=7"),"=8"),"=9"),"=10")

"Jerry Edge" wrote:

I have tried in xlsx, xlsm and xlsb and they all give me the same message. I
also get a message that the following feature cannot be saved in macro-free
workbook .VB project. It will not let me save it with a macro
--
Jerry Edge


"Sheeloo" wrote:

May be you are working on a file created in 2003 format - xls extension.

Save it as an xlsx file then you will get the increased numbers of If

"Jerry Edge" wrote:

I am working on a nested formula and if I put more than 7 formulas I get as
message that I have to many formulas, yet according to Excel 2007 help I
should be able to nest 64 formulas. Am i reading that wrong or is something
else going on?
--
Jerry Edge

Limits on nested formulas
 

On Thu, 14 May 2009 15:13:01 -0700, Jerry Edge wrote:

I am working on a nested formula and if I put more than 7 formulas I get as
message that I have to many formulas, yet according to Excel 2007 help I
should be able to nest 64 formulas. Am i reading that wrong or is something
else going on?

"to many formulas" is not an error message that you would get related to
excessive nesting (even in prior versions of Excel). Is that really what the
error message says?
--ron

Limits on nested formulas
 

I seem to have worked this on out. It now works. But yoiu are right, the
error message stated that it could not be saved in that format or workd to
that effect. I have another issue. I cannot save a file in with an xlsx
format which is 2007 standard file format, with a visual basic program. I
have a program that changes the size of a drop down box so that I can rerad
it when i click on it and then it boes bask to normal size when I click out
of the cell. When I try to save it with a xlsx extension I get the message,
"following feature cannot be saved in macro-free workbook .VB project Save
in another format."

Jerry


--
Jerry Edge


"Ron Rosenfeld" wrote:

On Thu, 14 May 2009 15:13:01 -0700, Jerry Edge wrote:

I am working on a nested formula and if I put more than 7 formulas I get as
message that I have to many formulas, yet according to Excel 2007 help I
should be able to nest 64 formulas. Am i reading that wrong or is something
else going on?

"to many formulas" is not an error message that you would get related to
excessive nesting (even in prior versions of Excel). Is that really what the
error message says?
--ron

Limits on nested formulas
 

On Fri, 15 May 2009 10:55:03 -0700, Jerry Edge wrote:

I seem to have worked this on out. It now works. But yoiu are right, the
error message stated that it could not be saved in that format or workd to
that effect. I have another issue. I cannot save a file in with an xlsx
format which is 2007 standard file format, with a visual basic program. I
have a program that changes the size of a drop down box so that I can rerad
it when i click on it and then it boes bask to normal size when I click out
of the cell. When I try to save it with a xlsx extension I get the message,
"following feature cannot be saved in macro-free workbook .VB project Save
in another format."

Jerry

Why can't you use one of the formats that allows you to save macros?
--ron

Limits on nested formulas
 

On Fri, 15 May 2009 10:55:03 -0700, Jerry Edge wrote:

I seem to have worked this on out. It now works. But yoiu are right, the
error message stated that it could not be saved in that format or workd to
that effect.

That makes more sense. You were probably trying to save a workbook that had
more than seven levels of nesting, as a 97-2003 compatible file.
--ron

Limits on nested formulas
 

I can and have but wanted to save in xlsx since I am sending the worksheet
out to many people, many who do not know anything about formats. It should
work unless they try to change it. Thanks for your help.

Jerry--
Jerry Edge


"Ron Rosenfeld" wrote:

On Fri, 15 May 2009 10:55:03 -0700, Jerry Edge wrote:

I seem to have worked this on out. It now works. But yoiu are right, the
error message stated that it could not be saved in that format or workd to
that effect. I have another issue. I cannot save a file in with an xlsx
format which is 2007 standard file format, with a visual basic program. I
have a program that changes the size of a drop down box so that I can rerad
it when i click on it and then it boes bask to normal size when I click out
of the cell. When I try to save it with a xlsx extension I get the message,
"following feature cannot be saved in macro-free workbook .VB project Save
in another format."

Jerry

Why can't you use one of the formats that allows you to save macros?
--ron