Leicester City Fox
Board Regular
- Joined
- Oct 7, 2016
- Messages
- 91
- Office Version
- 2019
- Platform
- Windows
Hi All
I need a excel formula that will work out the following weighted points from the original point issued to provider owing to number of Journeys that provider does a week.
The weighting of the point is as follows:
I have given an example of each weighting below with the result I am looking for applied to the weighting it should get.
I have workout the Weighted Actual Points (column D) manually but want a formula that automatically workout the weighted points on the original points issued (column C) owing to number of Journeys (Column B) that provider (Column A) should get.
Any Ideas of the simplest formula that will work out the weighting for each provider (column D).
Many Thanks
The Leicester Fox
I need a excel formula that will work out the following weighted points from the original point issued to provider owing to number of Journeys that provider does a week.
The weighting of the point is as follows:
- Provider has more 120 single journey per week – Points x 0.25
- Provider has 61 – 120 single Journeys per week = Points x 0.5
- Provider has 13 – 60 single journey per week – Points x 0.75
- Provider has 12 or less single journey the original point given stands (No Weighting)
I have given an example of each weighting below with the result I am looking for applied to the weighting it should get.
I have workout the Weighted Actual Points (column D) manually but want a formula that automatically workout the weighted points on the original points issued (column C) owing to number of Journeys (Column B) that provider (Column A) should get.
A | B | C | D |
Provider | Number Of Journeys | Original Points | Weighted Actual Points given |
A | 120 | 15 | 3.75 |
B | 80 | 10 | 5 |
C | 40 | 12 | 9 |
D | 12 | 3 | 3 |
B | 30 | 10 | 7.5 |
C | 8 | 15 | 15 |
Any Ideas of the simplest formula that will work out the weighting for each provider (column D).
Many Thanks
The Leicester Fox