topic Re: Rounding to given values in App Development

Rounding to given values

ahmada — Tue, 09 Jun 2020 17:05:22 GMT

Hello,

i have a question regarding rounding. I would like to round up a value from given numbers. This means that the value should correspond to the nearest number. This is how it should look like in the end:

Numbers

The average is 45!

I want the average to be rounded to the nearest number. So the closest number from the list to 45 is 50. The value 45 should be rounded up to 50 in the end.

Re: Rounding to given values

raji6763 — Wed, 10 Jun 2020 08:01:24 GMT

hi ahmada,

you can use Round() function .

Round() returns the result of rounding a number up or down to the nearest multiple of step shifted by the offset number.

Round(Numbers,10)

Regards,

raji

Re: Rounding to given values

ahmada — Wed, 10 Jun 2020 15:20:46 GMT

Hi Raji,

i know the round function but it doesnt work for this case. I wanted the average to match the closest value from the table. I hope you have an another solution.

Thank you very much