Salut Daniel,
Pourquoi du VBA
=SI(ESTERREUR(CHERCHE("-50%";A20));SI(ESTERREUR(CHERCHE("+ 25%";A20));F20*H20;F20*H20*1,25);F20*H20*50%)
Sinon
Private Sub Worksheet_Change(ByVal Target As Range)
Dim sForm As String, Lig As Long
Lig = Target.Row
sForm = "=SI(ESTERREUR(CHERCHE(""-50%"";A#));SI(ESTERREUR(CHERCHE(""+ 25%"";A#));F#*H#;F#*H#*1,25);F#*H#*50%)"
Application.EnableEvents = False
Range("J" & Lig).FormulaLocal = Replace(sForm, "#", Lig)
Application.EnableEvents = True
End Sub
@+