If Val(Text1) < 3 Then
Text2 = Val(Text1) * 10 * Val(Text1)
ElseIf 3 < Val(Text1) < 6 Then
Text2 = Val(Text1) * 15 * Val(Text1)
ElseIf 6 < Val(Text1) < 9 Then
Text2 = Val(Text1) * 20 * Val(Text1)
ElseIf 9 < Val(Text1) < 10000 Then
Text2 = Val(Text1) * 25 * Val(Text1)
End If