Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pocket Excel supports only some functions
Hi,
I notice that Pocket Excel (from PPC2003) only supports a small subset of the Functions available in the full Desktop version. Does anyone know of a resource that documents what is/isn't available? My specific problem right now is, Pocket Excel doesn't support the FLOOR() function. Anyone know a work-around? Thanks, Jon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pocket Excel supports only some functions
Hi Jon
=FLOOR(A1,B1) can be done as =INT(A1/B1)*B1 -- HTH. Best wishes Harald Followup to newsgroup only please "Jon Grieve" <jgrieve@southdown-co-uk skrev i melding ... Hi, I notice that Pocket Excel (from PPC2003) only supports a small subset of the Functions available in the full Desktop version. Does anyone know of a resource that documents what is/isn't available? My specific problem right now is, Pocket Excel doesn't support the FLOOR() function. Anyone know a work-around? Thanks, Jon |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pocket Excel supports only some functions
Ah, the irony... Seeing as I was doing FLOOR(A1,1), I can just use INT with nothing clever. The point is, Excel's interpretation of the INT function doesn't match mine. To me, INT should round down if the decimal places are less then .5, otherwise round up. e.g. INT(3.4999) = 3 INT(3.5) = 4 /me slaps hand to forehead. Thanks for the swift reply, Jon Harald Staff wrote: Hi Jon =FLOOR(A1,B1) can be done as =INT(A1/B1)*B1 -- HTH. Best wishes Harald Followup to newsgroup only please "Jon Grieve" <jgrieve@southdown-co-uk skrev i melding ... Hi, I notice that Pocket Excel (from PPC2003) only supports a small subset of the Functions available in the full Desktop version. Does anyone know of a resource that documents what is/isn't available? My specific problem right now is, Pocket Excel doesn't support the FLOOR() function. Anyone know a work-around? Thanks, Jon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pocket | Excel Discussion (Misc queries) | |||
What hyperlink method if any supports target rename? | Links and Linking in Excel | |||
pocket pc excel | Excel Discussion (Misc queries) | |||
Pocket Excel | Excel Discussion (Misc queries) | |||
How do I export an Excel spreadsheet to Pocket PC (Pocket Excel)?. | Excel Discussion (Misc queries) |