Hello Pan X Users!

Pan X does not seem to have a round down function (i.e., “rounddown(” in Excel), so I wrote the following substitute, which rounds down to the nearest ones place.

local Answer

Answer=?(round(((((round(XX,1))-XX)^2)^0.5),0.1)<0.5,(round(XX,1)),round(XX,1)-1)

Where “XX” is the number, number field, or mathematical equation in question.

I am posting this because: 1) this code might be useful to others (or at least, this discussion), and 2) to find out if there is a better way to round down, and 3) respectfully request rounddown, and roundup functions in future Pan X versions.

All the best,

Paul