Bonsoir Alf, bonsoir le forum,
Peut-être comme ça :
Sub Macro1()
Range("I29").Value = IIf(Range("B34").Value = 1, "0.50", "0.00")
Range("I30").Value = IIf(Range("C34").Value = 1, "0.50", "0.00")
Range("R29").Value = IIf(Range("D34").Value = 1, "0.50", "0.00")
Range("R30").Value = IIf(Range("E34").Value = 1, "0.50", "0.00")
Range("H31").Value = IIf(Range("H34").Value = 1, "0.30", "0.00")
Range("H32").Value = IIf(Range("H34").Value = 2, "0.50", "0.00")
Range("H33").Value = IIf(Range("H34").Value = 3, "0.80", "0.00")
End Sub
IIf fonctionne comme ça : IIF(Condition, si condition vrai, si condition faux)
[Édition]
Bonsoir James on s'est croisé...