Kristen Posted February 18, 2003 Share Posted February 18, 2003 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? Quote Link to comment
MullinRJ Posted February 18, 2003 Share Posted February 18, 2003 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 Quote Link to comment
Kristen Posted February 18, 2003 Author Share Posted February 18, 2003 Thank you, Raymond. I would NEVER have figured that out.... the documentation for VW9.5 shows a different format which does not work. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.