Archive for January, 2014

Excel – absolute minimum value

I’m meddling about with some stuff in excel just now (spit), and one of the things I wanted was to find the number in a set with the minimum absolute value. That is, the value closest to zero, whether negative or positive. In 3,5,7 this would be 3, in -3,-2,5,6 it would be -2. It’s […]

Read More…