Limits on nested formulas

  • Thread starter Thread starter Jerry Edge
  • Start date Start date
J

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?
 
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
 
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
 
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
 
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")
 
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")
 
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?
Click to expand...

"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
 
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?
Click to expand...

"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
 
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
 
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
 
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
Click to expand...

Why can't you use one of the formats that allows you to save macros?
--ron
 
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
Click to expand...

Why can't you use one of the formats that allows you to save macros?
--ron
 
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.
Click to expand...

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
 
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.
Click to expand...

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
 
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
 
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
 
Back
Top