What functions are currently included in Excel for iPad?

Question

Is there a list of the included functions somewhere? The desktop Excel products have something like 342 functions.

Answer 1

When creating / editing your spreadsheet,

select a cell

at the top of the screen, you will see the bar for typing your data or a function. That bar is labeled "Type here" in light gray text.

to the left of that bar, you will see "fx"

if you click the "fx" (which stands for functions), a drop down list box will display a list of recently used functions.

if you scroll down that list, you will see a complete list of all available functions, grouped by type of function.

Additionally, the ribbon bar appears at the top of the screen. In that ribbon bar, you will see "formulas."

click on "formulas" and you will see a row of types of functions, as well as "recent" functions and "..." for other types of functions, as there are too many types of functions to display all of them on the ribbon simultaneously.

Hope this helps!

Answer 2

Hi Carp,

I will provide you with the information that you require.

The available functions on Excel for iPad App are listed below:

• View the workbook or      spreadsheet using your iPad
• Create a new workbook or spreadsheet
• Cut copy and paste
• Search Add comments
• Enter numbers and text
• Calculate numbers
• Sort numbers
• Format text
• Save to
• Send to

Hope the information provided is helpful to you.

Thank you.

Answer 3

I think that carp3tsharp is looking for a listing similar to this one

http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP005204211.aspx

but that DOES NOT  identify those worksheet functions that are available on an iPad.  It is a general "here's what's in Excel 2010 [for the desktop]" listing.  I cannot find such a list myself.

That sheet has 333 entries for Functions, but the actual number is larger since it combines some of the TEXT functions entries such as LEFT and LEFTB into a single entry, and the list does not include .INTL variations of functions such as NETWORKDAYS.INTL

A list of features available (and not such as Pivot Tables) on the iPad would be nice also.  You can now seemingly only get an idea of what can/cannot be done with Excel (or Office apps in general) on an iPad either by trial and error or by reading lots and lots of 3rd party reviews.  Although I *think* that the list you provided is exactly that: a list of features available in Excel for iPad.