• 510K Members
• 6,281 Online
• 607K Conversations

New Contributor

# rounding a number to a set of other numbers

Hello,

I need to know how to make a formula that will round a number to a set of other number

ex. in the pic 2.7 should be rounded to 5 , and 16 to13 and 4 to 5 or 3

how to make this formula

thank you

# Re: rounding a number to a set of other numbers

Hi Abdullah,

I didn't catch the logic. If you'd like to find the closest from column C number to one from column B that could be

`=INDEX(\$C\$5:\$C\$10,MATCH(MIN(INDEX(ABS(\$C\$5:\$C\$10-B5),0)),INDEX(ABS(\$C\$5:\$C\$10-B5),0),0),0)`

But closest to 2.7 is 1, not 5. And why 4 is to be rounded to 5 or 3, from here 3 is appeared?

Related Conversations
Translation problem on Transifex
Duran Hsieh in Localization Feedback on
2 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Adding Display Zero as Dashes to Custom Excel Number Format
emmagreen in Excel on
1 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies
Power Query ::: Danish (or almost)
Jørgen Koch in Localization Feedback on
4 Replies