I have a data set that has five main values and each value has a different monetary payout to it. I need a to write a formula based on the five different values. For example:
Product Amount Payout
A 100.00 =if A, then amount * .05
B 100.00 =if B, then amount * .08
C 100.00 =if C, then amount * .17
D 100.00 =if D, then amount * .55
E 100.00 =if E, then amount * .75
The Product column will always offer the same values. The amount column may change but the payout column will not. What's the best way to write this query?
