I am having a simple problem In this part Of the following UDF
Code: Select all
ElseIf bCond2OK Then
Select Case LCase(Condition2)
Case "acceptable" ' ******************
Full = 0.4667 * TheValue + TheValue2 + Bonus2
' I want to add on the desired result multiply value of column C by 475% Plus multiply the value of column D by 105.73%
Case Else
Exit Function
End Select
This is what I've come up with so far, Please see the attachment file ...Thanks in advance