Forum home » Delegate support and help forum » Microsoft Excel Training and help » If functions

If functions

ResolvedVersion 2007

Tue 23 Dec 2008, 11:15 Delegate keith said...

keith has attended:
Excel Advanced course
Excel Advanced course
Word Advanced course
Word Advanced course

If functions

is there a limit to how many nested ifs can be used in a single function?

Tue 23 Dec 2008, 11:20 Trainer Mark said...

RE: if functions

Hi Keith

Thanks for your post hope you are enjoying your course

the answer to your question is that the limit to nested IF's is 64

As per the function wizard by clicking the FX button on the formula bar finding the IF function then clicking help on this function

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips

If functions

If functions

RE: if functions

Excel articles

Excel tip:

Using the Quick Access Toolbar in Excel2010