I am trying to apply a multiplier to a lookup field based on a checkbox or multiple selection.
In short, if the checkbox is checked, a lookup would be multiplied by a certain amount (for example 200), else it would not. Similar to:
IF ((checkbox)=1, LOOKUP*200, LOOKUP)
Another possibility would be:
IF ((multiple select)=A, LOOKUPx200, (multiple select)=B, LOOKUPx300,(multiple select)=C, LOOKUPx400)
Hope this is clear - strong text is this feasible?