I want to do this, but I can't figure out how...
in cell A, I want to return the following number...
the minimum value GREATER than zero when performing a simple subtraction of Cell B -Cell (C..F).
eg- Cell B has the number 5
Cell range c..f contain the following numbers: 3,6,7,9
I want a formula to compare the results of 5-3, 5-6, 5-7, 5-9 and return the smallest non-negative number to cell A. The answer in this case is 2.
But, how do I write a formulae to do this? I'm not an excel newbie, so it's ticking me off
in cell A, I want to return the following number...
the minimum value GREATER than zero when performing a simple subtraction of Cell B -Cell (C..F).
eg- Cell B has the number 5
Cell range c..f contain the following numbers: 3,6,7,9
I want a formula to compare the results of 5-3, 5-6, 5-7, 5-9 and return the smallest non-negative number to cell A. The answer in this case is 2.
But, how do I write a formulae to do this? I'm not an excel newbie, so it's ticking me off