Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how many if statements are allowed per cell?
|
#2
|
|||
|
|||
On Thu, 29 Sep 2005 12:43:04 -0700, "DallasM"
wrote: Lots. It is limited by the 32,767 limit on the length of cell contents. So the maximum number of IF's would have a varying limit depending on the length of each formula. However, if you are *nesting* functions, you may only nest seven functions. This applies to IF's as well as all the other functions. --ron |
#3
|
|||
|
|||
a formula can only contain 1024 characters when measured in R1C1 mode.
Although this is gonna change (as well as the nest limit): http://blogs.msdn.com/excel/default.aspx Ron Rosenfeld wrote: On Thu, 29 Sep 2005 12:43:04 -0700, "DallasM" wrote: Lots. It is limited by the 32,767 limit on the length of cell contents. So the maximum number of IF's would have a varying limit depending on the length of each formula. However, if you are *nesting* functions, you may only nest seven functions. This applies to IF's as well as all the other functions. --ron -- Dave Peterson |
#4
|
|||
|
|||
7 If statements or Functions per cell.
See workarounds at Chip Pearson's site. http://www.cpearson.com/excel/nested.htm Gord Dibben Excel MVP On Thu, 29 Sep 2005 12:43:04 -0700, "DallasM" wrote: |
#5
|
|||
|
|||
On Thu, 29 Sep 2005 15:07:39 -0500, Dave Peterson
wrote: a formula can only contain 1024 characters when measured in R1C1 mode. Thanks for the correction. --ron |
#6
|
|||
|
|||
Well I'll be damned, they're finally giving us that *million* Row XL.
There's such a major revamping, I wonder if there's anything left that they *didn't* add, as far as limits are concerned? Thanks for the link Dave. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Dave Peterson" wrote in message ... a formula can only contain 1024 characters when measured in R1C1 mode. Although this is gonna change (as well as the nest limit): http://blogs.msdn.com/excel/default.aspx Ron Rosenfeld wrote: On Thu, 29 Sep 2005 12:43:04 -0700, "DallasM" wrote: Lots. It is limited by the 32,767 limit on the length of cell contents. So the maximum number of IF's would have a varying limit depending on the length of each formula. However, if you are *nesting* functions, you may only nest seven functions. This applies to IF's as well as all the other functions. --ron -- Dave Peterson |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how many if statements are allowed per cell?
Thanks for the site...this is a great work-around!
-- Linda "Gord Dibben" wrote: 7 If statements or Functions per cell. See workarounds at Chip Pearson's site. http://www.cpearson.com/excel/nested.htm Gord Dibben Excel MVP On Thu, 29 Sep 2005 12:43:04 -0700, "DallasM" wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |