How can i round a number to closest tenth number?

Thread view:

Thread rating:

rayne95 - 19 Jun 2006 21:24 GMT

Hello, how can i round a number to the closest tenth?
i would really be happy if someone answered....!

Dave - 19 Jun 2006 21:30 GMT

Rayne95

Assuming your data is in A1 you can use

=ROUND(A1,1)

Dave

> Hello, how can i round a number to the closest tenth?
> i would really be happy if someone answered....!

Nick Hodge - 19 Jun 2006 21:31 GMT

Rayne

Using A1 as the number to be rounded

=ROUND(A1,1)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Hello, how can i round a number to the closest tenth?
> i would really be happy if someone answered....!

lk - 19 Jun 2006 21:34 GMT

using the =ROUND function

> Hello, how can i round a number to the closest tenth?
> i would really be happy if someone answered....!