Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to find the closest value to 50?


I've got a spreadsheet with a player number and points. I'd like to return the player number which is closest to 50. If there is more than one value, I'd like it to display both (or if not possible pick randomly)!

Thanks, Naomi

image description