trying to exceed the if statement max in excel 2000. I don't have the
experience necessary to write a function in vba. Can someone please help me.
This is what I am trying to accomplish.
I have 40 worksheets set up as bonus reviews. The review bonus dollar
amounts are based on the number of hours worked and the performance score.
Here is a shot in the dark at what I need in the vba module.
If $B$7 1000 AND $C$13 = "Good" Then
200
ElseIf $B$7 1000 AND $C$13 = "Excel" Then
400
ElseIf $B$7 1000 AND $C$13 = "Outst" Then
500
Elself $B$7750 AND $C$13 = "Good" Then
100
Elself $B$7750 AND $C$13 = "Excel" Then
350
Elself $B$7750 AND $C$13 = "Outst" Then
400
Elself $B$7500 AND $C$13 = "Good" Then
100
Elself $B$7500 AND $C$13 = "Excel" Then
225
Elself $B$7500 AND $C$13 = "Outst" Then
275
Elself $B$7350 AND $C$13 = "Good" Then
100
Elself $B$7350 AND $C$13 = "Excel" Then
200
Elself $B$7350 AND $C$13 = "Outst" Then
250
Elself $B$7155 AND $C$13 = "Good" Then
50
Elself $B$7155 AND $C$13 = "Excel" Then
75
Elself $B$7155 AND $C$13 = "Outst" Then
100
Else
0
End If
===================
$B$7 contains the hours and $C$13 contains the performance rating.
Thank you.
Bill