Pocket Excel supports only some functions

  • Thread starter Thread starter Jon Grieve
  • Start date Start date
J

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
 
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
 
Back
Top