Posted to microsoft.public.excel.misc

Garry R

external usenet poster

Posts: 1

Using nesting in the 64 IF function in Excel 2007

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nesting Limit 2007	bbal20	Excel Worksheet Functions	5	June 8th 09 12:49 AM
Excel 2007 problem nesting If & And	Steve	Excel Worksheet Functions	3	February 4th 09 09:08 AM
Excel 2007 problem nesting IF & AND	Steve	Excel Worksheet Functions	0	February 3rd 09 11:26 AM
Excel 2007 backwards compatibility - nesting functions	ilia	Excel Worksheet Functions	6	June 25th 07 05:58 PM
Nesting Networkdays function inside and If function	Addison	Excel Worksheet Functions	2	April 13th 06 08:04 PM

All times are GMT +1. The time now is 09:25 AM.

About Us

"It's about Microsoft Excel"