Worksheet giving wrong answer.

[Dexie]

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?

[VectorGeek]

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.

[Dexie]

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.

[VectorGeek]

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.