Corrigé Calc 2
REMISE 1 =SI(C5="oui";C10*2%;0)
SOUS TOTAL 1 =C10-C11
REMISE 2 =SI(C5="oui";SI(C10>10000;C10*5%;"0");"0")
SOUS TOTAL 2 =C12-C13
ESCOMPTE. =SI(C6="non";"0";SI(C5="oui";C10*3%;C10*2%))
TOTAL HT =C14-C15
TVA =C16*B17
FRAIS DE PORT =SI(OU(C7="OUI";C18>10000);"0";"50")
NET A PAYER =C18+C19
Modifié le: Tuesday 28 February 2023, 20:16