Limits on nested formulas

[Jerry Edge]

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?

 

[Sheeloo]

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]

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]

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

 

[Sheeloo]

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")

 

[Sheeloo]

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")

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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

 

[Jerry Edge]

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]

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

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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

 

[Jerry Edge]

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

 

[Jerry Edge]

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