https://docs.google.com/spreadsheets/d/1Dew-CLxHvMW2BgI9axdJTEI-2CezTx7k6Vt1R48mwgA/edit?usp=sharing
Above is the sample sheet. I need a formula in K cell
Google-sheets – Compare number in one cell to multiple cells and give out nearest number
formulasgoogle sheets
Related Topic
- Google-sheets – ArrayFormula to create a table of data from 1 column
- Google-sheets – Concat text from one column with text in non-empty cells in range
- Google-sheets – IMPORTRANGE QUERY formula filtered by dates range and values from cell
- Google-sheets – How to Copy Cell Value and Format From One Tab to Another Using a Formula
- Google-sheets – Countifs with index match and importrange
- Google-sheets – Change all unique country abbreviations to country names and place in one cell
Best Answer
You can use the following formulas
Closest minimum value
Closest maximum value
Functions used:
MINIFSMAXIFS