Round decimals to nearest quarter

[UnAndroid]

Hello! I am trying to round decimals to the nearest quarters, aka .25, .5, .75, 1.0, however I can't seem to figure out how to do that with the tools provided, even a place to look would be helpful!

[MultiTech]

wow yeah.... this is much more difficult than it should be.

@Arthur_Rallu We really need a 2nd parameter for ROUND()

[Marc_Dillon · Accepted solution]

ROUND( [decimal] * 4 ) / 4.0

[UnAndroid]

That works, thank you! though the reasoning behind that working is beyond me.

[Marc_Dillon]

>>"though the reasoning behind that working is beyond me."

I decided to answer this question in a separate Tips and Tricks post for greater visibility:

https://www.googlecloudcommunity.com/gc/Tips-Tricks/How-to-ROUND-to-whatever-interval-you-want/m-p/4...

[Muzekker_Vatan]

Dear Marc,

The formula gives me average time like 1.23345333 i need result as 1.23. Could you help me to round it? Thanks in advance. Which formula i need to use?

<<CONCATENATE(AVERAGE(SELECT(UKF[Duration per ULD],[DATE]>TODAY()-7)),” minutes”)>>

[Marc_Dillon]

Did you try reading the linked tips & tricks thread?

[Muzekker_Vatan]

Yes i did. But it goes up all the time. 
Below formula gives me result as 124. I need 123,27 for example.

<<CONCATENATE(ROUND(AVERAGE(SELECT(UKF[Duration],[DATE]>TODAY()-7))*2/2.0)” minutes”)>>