UM(B33),{0,1,2},{0.75,0.7,0.6}), 0)
In this example, the formula will check the value of cell B33 and if it is true (not equal to zero or blank) then it will return the result of multiplying the minimum value in cell B33 with a lookup table that contains three values (0.75, 0.7 and 0.6). If the val...