Formula limitations in Different Versions

[Tom]

Hi,

Are there any formula limitations in Excel version in Home and Student
vs. Business?

I am thinking about array formulas, VLOOKUP etc..

I currently have Office Professional XP and am now going to buy a Mac.
I am also retired and not as much a "power user" as I previously was,
however I wouldn't want to lose any capabilities.

thanks,

Tom

 

[Niek Otten]

Be aware that in the present version of Office for Mac you loose VBA
capabalities. That also means most (all?) add-ins won't work.

 

[Bob Greenblatt]

Hi,

Are there any formula limitations in Excel version in Home and Student
vs. Business?

I am thinking about array formulas, VLOOKUP etc..

I currently have Office Professional XP and am now going to buy a Mac.
I am also retired and not as much a "power user" as I previously was,
however I wouldn't want to lose any capabilities.

thanks,

Tom

No, Excel is identical between the home and student and business
editions on the Mac. there are no formula differences. Array formulas
and Vlookup work fine.