My first post in this forum, so not even sure if this is the right category.
Plase forgive me.

I just bought an Ipad to use for my flight school training. It's great for reading books and maps, aswell as a reference to everything.

I wanted to make a application to calculate some very basic stuff for me. It's mostly very basic weight and balance. Anyway, since I don't know programming very well, I decided to create a Excel spreadsheet insted. On my Windows desktop it's working perfect, but unfortunatly it seems like my Excel reader "Documents to go" do not support one of my formulas. I tried to google it, couldn't find anything helpful, but ended up on this forum a few times.

1) get Numbers and just build the forumla in that..
2) get Onlive Desktop and run your Excel spreadsheet in that. Can't be 100% sure it will work, but that excel is supposed to BE excel. You need good WiFI to use it.

You might be able to use CloudOn, but I have forgotten exactly what that app does (I have it installed, but it has been a while since I used it).

Are you sure this will work with Numbers? I were told that Documets to Go supported most formulas compared to other Ipad spreadsheets.

Click to expand...

It appears to me that Polaris Office supports the index, row, and small function. I didn't look closely at your use of these functions, but you might look at that app. It's on sale for $9.99 until May 15.

Are you sure this will work with Numbers? I were told that Documets to Go supported most formulas compared to other Ipad spreadsheets.

Click to expand...

No, I'm not sure at all. I should have said that. My guess is that you can modify whatever spreadsheet app you use to do the same thing. I think the other poster has a solution, but both seem to involve spending money.

Numbers does have the SMALL function. It returns the nth smallest value within a range (if that sounds right). All the other functions in your formula are also present, and at first glance look to be compatible.

Since I'm not sure I understand the formula and the desired results (haven't studied it hard enough yet) I can not guarantee it will work.

On your third post you should be able to include links. If you there is no private or sensitive data in the Excel spreadsheet (and you don't mind), go ahead and post a shared link (from DropBox or the like) and I will be happy to import it into Numbers and see if it works.

Include any explanations on how to use the spreadsheet if you think they are needed.

On further examination I don't believe Numbers can do this. The use of ranges in the IF function looks unlikely to work, and I don't know of any Numbers function that will return more than one value. You'd probably have to use some kind of string creation function to manage it.

Useful Searches

About iPadForums.net

iPadForums.net is a community dedicated to the Apple iPad. We discuss various topics including iPad Help, iPad Reviews, iPad Apps, iPad Accessories (such as iPad Keyboards, iPad Cases, iPad Covers), iPad Games and more.

iPadForums.net is not affiliated with Apple. We are an enthusiast site dedicated to everything Apple iPad (iPad 1 and iPad 2)