I figured if i seen the general fomula then I could figure out the rest. But here is a further example.

C1 has 3 possible values (1, 2 & 3) this represents the pay level of the installer
A2 has 3 possible values (New, Used & Service) this represents the job type
E3 has 3 possible values (RCA, Kenwood, Samsung) this is the product

With all these options there is a possible 18 differend outcomes so here is 3.

if C1 is 1 and A2 is New and E3 is RCA then F3 should be 37.50
if C1 is 1 and A2 is used and E3 is RCA then F3 should be 17.50
if C1 is 1 and A2 is Service and E3 is RCA then F3 should be 12.00

How do I write this as one?