Certainly looks messy and there probably is a better way, however, perhaps you could expand on exactly what you are trying to achieve; think I may be able to help more then. (STD.MIN ??
).
The formula certainly works in theory, i.e.
It returns the integer value of the sum of three other values; but without a real-world scenario to make a comparison to it is difficult to see a better way.
Also did you mean (a1-INT(a14)) or should that be (a1-INT(a1))?
[ 12 August 2001: Message edited by: Icarus ]