Asking for Formula Help

[ChrisHockley]

Guys, I'm always amazed at how much help everyone is here and how experienced those that are here actually are!

I'm trying to round numbers with two decimal places to one decimal place.

Here are the parameters:
1. Anything 3.54 and below should be rounded up or down to the nearest tenth or 0.1
2. Anything between 3.54 and 28.34 should be rounded up or down to the nearest 0.5
3. Anything 28.35 or above should be rounded up or down to the nearest 1.0

Can this be done in one formula so that I don't have to copy and paste multiple versions over thousands of lines?

Thanks in advance!

 

[Cubist]

Try:

=MROUND(D296,XLOOKUP(D296,{0,3.54,28.34},{0.1,0.5,1},,-1))