Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Actually, I think Numbers can do this, it does have sumproduct. But there is plenty it can't. Every time I try to use it, I find something missing.

Not quite sure about that in this case. I'm not using sumproduct here in the conventional sense. In Numbers it does have a simplified way to use the function purely for multiplying one array of numbers times another... but what I'm doing is closer to an offset-match, trying to identify unique records in specified ranges on two or more criteria.

From what I've read, Numbers' sumproduct function doesn't go this far. But yeah, there's plenty of other things I do that it definitely can't facilitate yet.
 
Not quite sure about that in this case. I'm not using sumproduct here in the conventional sense. In Numbers it does have a simplified way to use the function purely for multiplying one array of numbers times another... but what I'm doing is closer to an offset-match, trying to identify unique records in specified ranges on two or more criteria.

From what I've read, Numbers' sumproduct function doesn't go this far. But yeah, there's plenty of other things I do that it definitely can't facilitate yet.

I see what it is, don't worry. I think I tried a full-on, data-pull array sumproduct once, just can't remember if it worked or not. I don't think I care enough to try again. :D
 
Looks like this is a classic example of "if you can't beat them, join them," which is an improvement over the typical MS practice of "if you can't beat them, copy them." :apple:

Smart choice on the part of Ballmer & Co. Some money is better than no money. Some money? Or No money?

What are you talking about? Microsoft are a software company. They make money from software.

They make so much from Windows machines that it's only logical to expand Office to tablets. Office for iPad has been in development for a long time...
 
Wow this is awesome. If this comes out before Office on the MAS... I might just sell my MBP and use an iPad for uni (and client meetings!). That would be incredible. I'm excited, I think Apple is going to have an incredible year this year.
 
No big deal

I've been using and editing Word and Excel documents on my iPhone and iPad using Documents to Go since it was released for those devices. Works great, and I can sync files between those devices and my Macs, as well as create new ones on those devices.
 
To my big surprise, iOS cannot display Word Documents with revision tracking marks. It just tells me that the document is not supported.

I hope that Microsoft Office will remedy this big problem.
 
Oh, I have no doubt that offices see OFFICE as the "gold standard", but the question is "why?" Price is huge (compared) and function is similar to iWork. The offices I have worked in could have easily used iWork, especially since many people used Macs, but they were using OFFICE instead... for Mac.

It just seems like most corporate people are locked into a perception or fear of prudent change because it could send them off the rails on a crazy train. Or something.

Really... the why is because it has been widely adopted for years long before iWork. It is a Microsoft Product and it runs seamlessly in Windows. Now add in the fact that schools, goverments, and large corporations, find it very easy to maintain and deploy windows/microsoft office all as one package on any IBM machine and you can see why people still use office.

It is a bit different for the average consumer who chooses their individual pcs/macs and has infinite control on what they wont on their machine. Not so for corporations who by in bulk and manage in bulk. They need a simple distribution process software that most people in the company know how to use.

Maybe one day it will change but at this point it is what it is, and like others have posted having it on the iPad can only help iPad sales.
 
This appeals to me as a Windows 8 user as it means I can easily transfer work between iPad and my desktop without them being in the same ecosystem. But, does anyone know whether Word for iPad will likely have a feature to save documents straight to Microsoft's Skydrive? That would be the deciding feature for me.
 
I suspect the lack of an Android version at this point has a lot to do with how easy it is to pirate stuff on the platform. Google will probably need to do more to stop it, if MS are to ever release it for Android.

If they make android users buy a product key for MS office this would cut down on the piracy.

----------

Forget all this office and iworks. I'm waiting for an open office for ipad to come.

Its free and almost as good as ms office
 
Conversely Apple should be doing the same, selling iWork for PC's and Android.

A friend of mine loved how I have pages on both devices and that I can work and edit it on both my Mac and my iPhone. There isn't an Android version that can do that, there are versions but you usually have to either change the file format from one and another or use a 3rd party cloud source, non do it effectively as Apple. My friend can't afford to get a Mac and an iPhone but it would a great tool for their college work. If Apple offered iWork for other computers and priced them competitively then they could make some decent money from it.
 
Great News - iPad More Useful With Microsoft Office

Great news and moves the usefulness of the iPad forward in a significant way.

Some have questioned why use Microsoft Office (specifically Word and Excel) as opposed to Apple products. The short answer is Apple products are too proprietary for the general public and, unfortunately, do not work in the business world as easily or broadly as do Microsoft Word and Excel.

P.S. And I detest Word and Microsoft, but it has a tremendous lock on the business world despite the fact that are much better products.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.