Table sum roundup

[gandi.nbgd]

Hello,

I need some help with rounding sum numbers in autocad table. Tried some things like round() and trunc(), but it doesn't work, or I'm doing something wrong.

All this areas are linked to hatch in model, and their field looks like this: (with conversion factor of 0.0001 (cm2-m2))

All I need is simple thing at first, sum at the end to use this two decimal numbers when doing the math, and not the whole 164.366344 for example. So end result needs to be 2420.61 instead of 2420.59.

Thanks in advance!

[Patchy]

It works that way same as excel.

[JTBWorld]

Try something like this:

round(a1*100)/100 +round(a2*100)/100 +round(a3*100)/100

[gandi.nbgd]

No luck, same wrong number

[JTBWorld]

Can you upload a sample DWG? 

[gandi.nbgd]

Here is one example of this problem

[cadffm]

Autocad fields alway calculate with the real values, not with your display values

[JTBWorld · Accepted solution]

You need to use this:

=round(b1*0.01)/0.01 +round(b2*0.01)/0.01 +round(b3*0.01)/0.01+round(b4*0.01)/0.01

[gandi.nbgd]

Worked, thank you very much !

[st19675]

Hello to everyone,

Thank god finally found the solution to a similar problem I have.

Hope someone can solve my problem:

I have a table with Object Area Fields inside. Also I have a column sum. I would like to roundup numbers like: 82.09 to 82.10, 1.66 to 1.70, 83.03 to 83.00....

Hope someone can help me.

Thanks a lot in advance 🙂

 

[JTBWorld]

Round 83.03 to 83.00 or 84.00?

[st19675]

Thank you for your fast answer Jimmy,

I need to round up  from 0.05 up or round down from 0.04 down, as for example: 73.91 to 73.90, 75.56 to 75.60, 5.25 to 5.30, etc

Thanks a LOT 🙂

[JTBWorld]

That would be like this: round(A1*10)/10

[st19675]

Finally it worked like this:

ROUND(A1/0.05)*0.05

Thank you very much!

[wquevedoPBBV4]

Thank you so much.