formulas from 2007 to 2003

[confused!!]

are formuals in 2007 compatible with 2003 with the exception of saving the
worksheet as compatible with 2003

 

[Chip Pearson]

Excel 2007 added some new formulas (IFERROR, SUMIFS, and others) so
these will not be compatible with 2003. Also, functions that in 2003
and earlier were part of the Analyis Tool Pack were made native
functions in 2007, so in 2003 you'll have to load the ATP.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Bernard Liengme]

Chip has given you a full answer but you might also need to know that XL2007
allows full column references in array formulas. So in XL2007 I can use
=SUMPRODUCT(--(A:A="Apple"),
--(B:B="Granny Smith"), C:C)
This will not work in earlier versions

 

[David Biddulph]

.... and there's the level of nesting. Is it 64 in 2007 and 7 in 2003? ...
and of course the number of rows and columns available, and ....

A more detailed list of what's different in 2007 is at
http://technet.microsoft.com/en-us/library/cc179167.aspx and another at
http://office.microsoft.com/en-us/help/HA100738731033.aspx