View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hal mcl Hal mcl is offline
external usenet poster
 
Posts: 2
Default Excel 2007 balks at 7 nested IFs

I am trying to use a formula with 13 nested IFs in Excel 2007. But I get a
message that the formula "uses more levels of nesting than are allowed in the
current format" whether I am using xlsx, xlsm or xlsb. Excel 2007 is supposed
to allow up to 64 nestings but I find it balks at more than seven.
--
Hal