Thread: Using nesting in the 64 IF function in Excel 2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Using nesting in the 64 IF function in Excel 2007
By any chance is your file an .xlS instead of 2007 format. If so, save save
as .xlsx closereopen.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Garry R" <garryr*yahoo.com wrote in message
...
I'm trying to have 20 arguments in the IF function and it will only let me
do
7. I thought excel 207 allowed 64. What am I doing wrong?

Reply With QuoteReply With Quote