Find not exact amount

[srizki]

I am trying to find an amount closed to $1,174 + - $50, or any amount close to this amount.

 

[taigovinda]

If you have a column of numbers, starting in A2, try this starting in B2:

=abs(a2-1174)<50

...then you can filter on column B to get all the cells fitting the criteria.

 

[ravishankar]

Hi
If you are searching for a match in col A
B2= Vlookup(1174,A2:A78,1,true) will return the number closest to 1174 (lowerside)
Ravi

 

[srizki]

Thank you that will work.

 

[Kelbo]

The Vlookup formula will not find the nearest value to 1174 unless your data is in ascending order. It actually gives the value nearest to 1174 minus 50.

The formula:

{=MIN(ABS(1174-$H$2:$H$13))}

Entered by Ctrl-Shift-Enter

will give you the smallest difference between actual value and wanted value.

Kelbo

 

[srizki]

Thank you Kelbo