round up to one decimal

**rcprito** · 04-19-2013, 06:07 AM

If CheckBox1.Value = True Then
Label10.Caption = (x * z1) / (y1 * z1)
End If

hey guys, I would like Label10.caption would capt only one decimal.

I've already tried application.roundup etc, but it doesn't work..

can someone help me?

thanks a lot

**:) Sixthsense :)** · 04-19-2013, 06:14 AM

Try this...

Please Login or Register  to view this content.

**bodhi808** · 04-19-2013, 06:16 AM

I think this might work for you.

Please Login or Register  to view this content.

**jindon** · 04-19-2013, 06:16 AM

Tried like this?

Please Login or Register  to view this content.

**rcprito** · 04-19-2013, 07:17 AM

thanks a lot guys. it's working.

I have another question.

How can I do it but to round it UP or DOWN ?

Imagine, 149,5 goes to 150 and 149,4 goes to 149 ?

Thanks a lot

EDIT : already done it. Thanks anyway!