I've been scratching my head for the past week to try to do this calculation

I have the following cells

D E F G

Pts Status Type End Pt

For D (Pts). I will have the following numbers

100

200

300

400

For E (Status)

W

L

H

P

V

For F (Type)

S

P

For G (End Pts) This is the final calcuation with the following scenarios

For G (End Pts) This is the final calcuation with the following scenarios

If

- D = 100, E = W, F = S, then G should = D

- D = 100, E = L, F = S, then G should be D*-110%

- D = 100, E = P, F = S or P, then G should be 0

- D = 100, E = H, F = P (Only scenario), then G should be D*90%

- D = 100, E = W, F = P, then G should = D

- D = 100, E = W, F = P, tehn G should = D*250%

thanks in advance