Option Explicit
Public Function test(Cellule) As Currency
If IsEmpty(Cellule) Or Not IsNumeric(Cellule) Then Exit Function
Select Case Cellule
Case Is <= 630
'
Case Is <= 1500
test = 0.2 * Cellule - 126
Case Is <= 4000
test = 0.3 * Cellule - 276
Case Is >= 4000
test = 0.35 * Cellule - 476
Case Else
'
End Select
End Function