HI All,
I need to create a spreadsheet to "assign" a certain value to an individual score i.e. if Joe bloggs scores 85% for attendance he receives x points, if he receives 44 for performance he receives x points.
The Layout of my table needs to be similar to the the one below
Name Sickness Punctuality Performance
Joe Bloggs 85% 90% 54%
Joe Bloggs 2 25% 15% 85%
Joe Bloggs 3 50 50 50
i am presuming i would then need to have a data range table to show what points it would be for the certain score. i.e
Range Sickness Punctuality Performance
0-10% 5 5 5
Has anyone any idea on how i would do this or what functiosn to use??
THanks in advance
I need to create a spreadsheet to "assign" a certain value to an individual score i.e. if Joe bloggs scores 85% for attendance he receives x points, if he receives 44 for performance he receives x points.
The Layout of my table needs to be similar to the the one below
Name Sickness Punctuality Performance
Joe Bloggs 85% 90% 54%
Joe Bloggs 2 25% 15% 85%
Joe Bloggs 3 50 50 50
i am presuming i would then need to have a data range table to show what points it would be for the certain score. i.e
Range Sickness Punctuality Performance
0-10% 5 5 5
Has anyone any idea on how i would do this or what functiosn to use??
THanks in advance