Vba sum formule

Hello,

I have this:

Please Login or Register  to view this content.

Although when i execute the formule, instead of appear "19 250"

It shows a different Value, can someone help me on this?

You can check in the file attach

I need that the cell format would be like "1 000" or "100 000"

Separated with spaces, i formatted the cell as: "# ##0"
I want it to be in Units like
1,5 = 2
1,4 = 2
100,55 = 101
15125,515 = 15 126
Always for the next unit above.

Hope someone can help

Originally Posted by mikerickson

The code is dimensioning MetrosLineares as a string. It should be a Double.

Adding ROUNDUP to the code will produce the results that you want.

I don't know what you mean about roundup. How can i do that?

I can do as well dimenstion metroslineares as double..

I already dimentioned MetrosLineares to Double and it solved the problem.

Thanks