Rounding to given values

[ahmada]

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

10

30

50

90

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.

[raji6763]

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

[ahmada]

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