tlchan
08-06-2008, 04:55 PM
I have a scorecard to calculate the scoring for each staff.I'm using If function to compute the rating from 1 to 5 under column K.
Is there any VBA to replace the function ?
How about the reverse of the rating (eg the smaller number achieved, the higher the rating)?
workbook attached
Is there any VBA to replace the function ?
How about the reverse of the rating (eg the smaller number achieved, the higher the rating)?
workbook attached