Pocket Excel supports only some functions

[Jon Grieve]

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

 

[Harald Staff]

Hi Jon

=FLOOR(A1,B1)
can be done as
=INT(A1/B1)*B1

 

[Jon Grieve]

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