How can i round a number to closest tenth number?

[rayne95]

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

 

[Dave]

Rayne95

Assuming your data is in A1 you can use

=ROUND(A1,1)

Dave

 

[Nick Hodge]

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]

 

[lk]

using the =ROUND function