Rounding In Excel Question

[Airbiskit]

I have search for an answer to a rounding question I have but cannot seem to find what I am looking for.

I want to round some values in excel to the nearest .1

For example...

21.34 would round down to 21.30
12.78 would round up to 12.80
12.45 would round up to 12.50

Can you help please.

Thanks

Steve

 

[GlennUK]

Use the ROUND function, like this:

=ROUND(cellref,1)

Cheers, Glenn.

 

[lupins46]

=int((value * 10 + 0.5))/10

 

[Airbiskit]

Thanks for the fast response.

Tried lupins suggestion and this done the trick apart from when you get .95 .96 .97 etc.

In this case it rounds it down because it cannot add the whole number.

But I can work around this.

Glenn thanks for replying I will have a look at your suggestion aswell.