Thread: is there a limt to the amount of if statements you use in just 1 c
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
scottfoxall scottfoxall is offline
external usenet poster
  
Posts: 40
Default is there a limt to the amount of if statements you use in just 1 c
The max is 7 IF statments in 1 cell. You can a pyramid structure to get more
but using the VBA is a better solution.

"unouwanme" wrote:

I am trying to use 10 if statements in 1 cell, but keeps coming up with an
error, but is ok when i delete 2...

Anyone know?
Reply With QuoteReply With Quote