Hello members,
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
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