View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eeldav eeldav is offline
external usenet poster
 
Posts: 1
Default Maximum IF Statements in a Formula

Excel HELP seems to indicate that the maximum number of IF statements in a
formula is seven. I have successfully designed formulas with 12 IF
statements. I am wondering just what the limits are?

I have written a formula exceeded the limits on the number of characters in
a formula. I suspect that limit might be 1,000 characters. If anyone knows
the limit on the number of characters in a formula, I would be interested in
that limit too.
--
eeldav