Dexie Posted February 15, 2016 Share Posted February 15, 2016 I have a simple worksheet which does some calculation for a development site. All columns seem to match except the final calculation to work out the square footage per acre, Value=F24/D27 (43692/2.30acres) Result = 19012.807 Which is wrong But if I put F24/2.30 Result = 18996.522 What is going on, I need to rely on these figures being correct. Any ideas? Quote Link to comment
VectorGeek Posted February 15, 2016 Share Posted February 15, 2016 Dexie: This is happening because of rounding. You are rounding cell D27 to two decimal places, so 2.29803 is becoming 2.30. Vectorworks is using the actual number (2.29803) and calculating the correct answer: 43692 / 2.29803 = 19012.81 (rounded to 19013). In your example above, you are truncating the value to 2.30 and getting a (slightly) different result, which is expected. Hope that helps, The Geek. Quote Link to comment
Dexie Posted February 16, 2016 Author Share Posted February 16, 2016 Thanks for that, it makes sense. But is there a way limiting all calculations to using 2 decimal places rather than 4 or 5 if you see what I mean. I suppose I should have entered the actual value for acres rather than the figure derived from from converting hectares to acres. Quote Link to comment
VectorGeek Posted February 18, 2016 Share Posted February 18, 2016 Dexie: There is a way, but it requires an extra cell. Assuming you have the value 2.29803 (or any value between 0-10) Create a cell with the formula: =ROUND(D8*100)/100 That will round the value to two decimal places Now base your calculations on the value in this new cell. Math is fun, english is funner! V-G. 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.