Thread: How do I nest more then 7 IF's?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
M Kan M Kan is offline
external usenet poster
  
Posts: 169
Default How do I nest more then 7 IF's?
Are you trying to use this to catagorize a data set or summarize by several
criteria? As far as I know, you can't nest more than 7 IF statements.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"KenCanuck" wrote:

I need to nest about 13 IF functions in one formula, can I do this?
Reply With QuoteReply With Quote