Truebluedan
New Member
- Joined
- Aug 11, 2021
- Messages
- 7
- Office Version
- 2013
- Platform
- Windows
Morning
This is really stumping me and if possible could somebody help me the formula.I’ve attached a screenshot to make it easier. Each person in Column A is given a monetary amount based on what tier they work in (column B). Each tier has a value if target is achieved.
Tier 1 €50
Tier 2 €150
Tier 3 €225
Each person needs to hit a minimum in column c and d to receive the reward.
Column C target is greater than 16 whilst column D target is greater than 24.54%. Column E would then return the monetary value achieved. Anybody not hitting either of the targets would receive 0.
Can anybody help please?
Thanks
Dan
This is really stumping me and if possible could somebody help me the formula.I’ve attached a screenshot to make it easier. Each person in Column A is given a monetary amount based on what tier they work in (column B). Each tier has a value if target is achieved.
Tier 1 €50
Tier 2 €150
Tier 3 €225
Each person needs to hit a minimum in column c and d to receive the reward.
Column C target is greater than 16 whilst column D target is greater than 24.54%. Column E would then return the monetary value achieved. Anybody not hitting either of the targets would receive 0.
Can anybody help please?
Thanks
Dan