Can I nest functions?

J

Juan Sanchez

Excel's limit for nesting is 7... i.e

=IF(A1<>0,A1,IF(B1<>0,B1,IF(C1<>0,C1,...IF
(G1<>0,G1,H1)))))))

Cheers
Juan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Fields Nested Too Deeply" Error in Simple Word Document 5
Page numbering with Merged Document and IF statements 1
Simple nested if and statement 2
Microsoft word: fields are nested too deeply 1
IF function says too many nested 1
Fields are nested too deeply 2
Excel - Wich Function should I use? 1
Mac Office 2011: Convert Powerpoint Outline to Word? 0

Top