Rounding up or down depending on...

[Liam660]

When it comes to rounding I use excel like everyone else. I’ve recently come across an engineering specification that rounds up or down to an even decimal place if the second decimal ends in a 5. i.e 2.45 to 2.4, 2.75 to 2.8 and normal rounding occurs otherwise 2.44 to 2.4, 2.74 to 2.7 and 2.53 to 2.5.
If anyone could point me in the right direction I appreciate it.
Thanks

 

[mole999]

=round(cell,1) does that all except for 2.45 to 2.4. I suppose you could throw a IF test in and force ROUNDUP OR ROUNDDOWN

 

[Tetra201]

Maybe

=MROUND(A1,0.2)