PDA

View Full Version : Replacement of IF function



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

mikerickson
08-06-2008, 05:03 PM
Replacing that function with VB will degrade the performance of the spread sheet.

To change the current formula from 1(low) - 5(high) to 1(high) - 5(low), change the formula to

=6-currentFormula