Thread: expression length
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default expression length
Before xl 2007, 7 nested ifs' Have a look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tcek" wrote in message
...
What is the maximum length that an "IF" function expression. I have an
expression that gives and effor message and I think excel is attempting to
truncate it.

Reply With QuoteReply With Quote