An alternate way to approach this is with the SWITCH function, which can often be more compact (and easier to edit) than a bunch of nested IFs. With the two levels in the above example, the equivalent formula using SWITCH would be:
SWITCH({PH}, 3.1, {Qty Pressed L}*0.5, 3.2, {Qty Pressed L}*0.6)
SWITCH is great when you want to pick between one of several output values based on the value of a single field (or a formula involving a single field). In this case, the output all depends on what’s in {PH}, which is why it appears as the first argument. The arguments after that are in pairs, with the first in each pair being the value to look for, and the second being the desired output if that value is found.
Also, because the output is always {Qty Pressed L} multiplied by some value, we can simplify this even further:
{Qty Pressed L} * SWITCH({PH}, 3.1, 0.5, 3.2, 0.6)
This version looks at {PH}, and outputs the necessary value to multiply with {Qty Pressed L}, rather than inserting the full calculation as the output.
