how to roundup and round down textbox value

[manissinha5]

Hi All,

I have created userform and want to roundup and round down the entered values

If i enter positive value with decimal value it should round down
example if i enter 5.01 it should give 5.00 , or for 5.99 should give 5.00

If i enter negative value with decimal value it should round up
example if i enter 5.01 it should give 6.00 , or for 5.99 should give 6.00

regards
manish

[ikboy]

try this:

Please Login or Register  to view this content.

[svg3414]

Which figure do you want to round? The sum or the individual entries?

[Phuocam]

Try:

TextBox3.Value = Int(Val(TextBox1.Value) + Val(TextBox2.Value))

[manissinha5]

individual entries