Thread: NESTED IF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default NESTED IF
Hi
7 nested IFs
if you need more the 7 nested comparisons I'd suggest to use VLOOKUP or
similar functions

Frank

D.S. wrote:
What is the maximum number of nested IF statements in a worksheet
formula?


Reply With QuoteReply With Quote