To be able to use this function easily in each case paste this command
into a Visual Basic Project, Macro Module:
Function Factor(Years)
If Years 51 Then
Factor = 2
ElseIf Years 41 Then
Factor = 1.5
Else
Factor = 1
End If
End Function
Therafter you will find this function in Insert Function User
Defined Functions
Alternatively you can use a function in cell:
=IF(A451,2,IF(A441,1.5,1))
Tomek Polak
www.vba.blog.onet.pl