Forum Discussion
Worst case calculation
Hello, I would like a help to identify which formula I use to calculate the worst case, for example, I have two values: -0.20% and 0.08%, I need the final disposition or the worst case (-0 , 20%) is identified in the result.
7 Replies
Adrieloliveira , you are welcome
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.
