worksheet operation =round?

[Kristen]

I cannot get the "round" function to work (page 16-27 of the VW manual).

=ROUND(((AREA(C='repoint'))/144),3)

I'm using "int", but it's a poor substitute for rounding.

=INT((AREA(C='repoint'))/144)

Has anyone else used "round" successfully?

[MullinRJ]

Kristen,

I just tried it in VW8.5.2 and ROUND only accepts 1 argument, but the documentation shows that it accepts 2. Probably an error in the documentation, or just wishful thinking.

Try: =Round(123.456789*10^3)/10^3

to get 3 decimals of precision, where 10^3 is 10 raised to the 3rd power, or 1000. Change the 3 to whatever precision you desire.

This should evaluate as:

Round(123456.789)/1000 -> 123457/1000 -> 123.457

HTH,

Raymond

[Kristen]

Thank you, Raymond. I would NEVER have figured that out.... the documentation for VW9.5 shows a different format which does not work.