How can i round a number to closest tenth number?

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

Rayne95

Assuming your data is in A1 you can use

=ROUND(A1,1)

Dave

"rayne95" <[email protected]> wrote in message
news:[email protected]...
> Hello, how can i round a number to the closest tenth?
> i would really be happy if someone answered....!
>

Rayne

Using A1 as the number to be rounded

=ROUND(A1,1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"rayne95" <[email protected]> wrote in message
news:[email protected]...
> Hello, how can i round a number to the closest tenth?
> i would really be happy if someone answered....!
>

using the =ROUND function

"rayne95" wrote:

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