excelgal2016
New Member
- Joined
- Dec 14, 2016
- Messages
- 20
- Office Version
- 2019
- Platform
- Windows
I've been trying to come up with a formula for a total - single score based on 4 variables. I'm afraid it's just a task too big for my old brain. It's perhaps not even a proper Excel question (I am using Excel to analyze the data though!).
I have 4 columns with a range of performance values for individual employees. I'd like to compare employee performance based on a single total score. Example:
Anyone can think of a formula how to calculate a single score from the 4 ratings? I'd very much appreciate the help.
I have 4 columns with a range of performance values for individual employees. I'd like to compare employee performance based on a single total score. Example:
Anyone can think of a formula how to calculate a single score from the 4 ratings? I'd very much appreciate the help.