Limiting "=min" to positive answers

is there only two values always?

Hi,

Does this help?

=ROUNDUP(MIN(ABS(F47),ABS(F48)),0)

Try this Array Formula

=MIN(IF(F47:F48>0,F47:F48))


Array Formulas. are little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

Surely Sweep's solution breaks down if the absolute value of the negative value is less than then absolute value of the positive value: -14 and +20

I agree with Glenn, I tested both using 110 and -100 and Sweep's returned a positive 100 which from your original post isn't what you wanted, Glenn's worked - for what it's worth.

as there is some adversion to array formula and there are always only two values


try this

Formula:

Please Login or Register  to view this content.

not sure what you want to do when both are negative so i put in place holder text

Originally Posted by TCH86

I'll probably not try the array, as I would then need to add an explanation text box for this one cell.

Originally Posted by humdingaling

as there is some adversion to array formula

Here's a normally entered (non-array) version as you're using Excel 2010...

=IFERROR(AGGREGATE(15,6,F47:F48/(F47:F48>0),1),"")