Forum Discussion

Adrieloliveira's avatar
Adrieloliveira
Copper Contributor
Feb 11, 2020
Solved

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 ...
  • SergeiBaklan's avatar
    Feb 11, 2020

    Adrieloliveira 

    Few variants, for example

    =IF(ABS(MIN(A1:A2))>MAX(A1:A2),MIN(A1:A2),MAX(A1:A2))

Resources