=IF(B33,MIN(B33)*LOO

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 value of cell B33 is false (equal to zero or blank), then the formula will return a value of zero (0).