Forum Discussion
Worst case calculation
In fact, I need the formula to identify the worst case, both for positive and negative values, for example: -0.20% and 0.08%, the worst case is -0.20%, but the opposite may occur also, to show 0.20% and -0.08%, where 0.20% would be the worst case, and in the resolution of the formula, the worst case value must appear.
"Worst" is a relative term. Please explain why -0.20 is worst than 0.08 and 0.20 may be worst than -0.08. If "worst" means "lower than", -0.20 is worst than 0.08 and -0.08 is worst than 0.20.
If both values are in, e.g. A1 and A2, a formula like
=MIN(A1:A2)will give you the lowest value of the two.
Imagine the zero point of the Cartesian "X" axis, now imagine these values that I mentioned distancing from the zero point, for me the worst case is the one that has moved further away from point 0, regardless if it went to the positive or negative side, the that most distanced itself would be the worst case, the formula that I need has to identify the value that is farthest from zero, regardless of whether positive or negative.
