View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default formulas from 2007 to 2003

.... 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/l.../cc179167.aspx and another at
http://office.microsoft.com/en-us/he...738731033.aspx
--
David Biddulph

"Bernard Liengme" wrote in message
...
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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"confused!!" wrote in message
...
are formuals in 2007 compatible with 2003 with the exception of saving
the
worksheet as compatible with 2003