calcul heure sup

%3CLINGO-SUB%20id%3D%22lingo-sub-2959867%22%20slang%3D%22fr-FR%22%3Ecalculation%20hour%20sup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2959867%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20would%20like%20to%20indicate%20in%20a%20cell%20the%20remaining%20number%20of%20the%20subtraction%2C%20we%20will%20say%2041-35%20that%20it%20shows%20me%20the%20result%20but%20also%20if%20this%20subtraction%20exceeds%207%20and%20although%20it%20shows%20me%207.%3C%2FP%3E%3CP%3Eand%20in%20another%20cell%20if%20the%20result%20is%20less%20than%207(%20ex%3A41-42)%20and%20well%20meter%200%20and%20if%20the%20result%20of%20ex%3A%2045-42%20and%20well%20put%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2959867%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2959967%22%20slang%3D%22en-US%22%3ERe%3A%20calcul%20heure%20sup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2959967%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20sorry%20the%20French%20translation%20is%20pretty%20bad%20but%20it%20sounds%20like%20you%20want%20to%20do%20a%20subtraction%20(I%20will%20give%20an%20example%20using%20A1-A2)%20but%20show%20a%20min%20of%200%20and%20max%20of%207%3A%3CBR%20%2F%3E%3DMIN(7%2C%20MAX(0%2C%20A1%20-%20A2))%3C%2FP%3E%3CP%3Eor%3C%2FP%3E%3CP%3E%3DMEDIAN(0%2C%207%2C%20A1-A2)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2960070%22%20slang%3D%22fr-FR%22%3ERe%3A%20calculation%20hour%20sup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2960070%22%20slang%3D%22fr-FR%22%3Edoes%20not%20work%3C%2FLINGO-BODY%3E
New Contributor

bonjour,

je voudrais indiquer dans une cellule le nombre restant de la soustraction, on va dire 41-35 qu'il m'affiche le résultat mais aussi si cette soustraction dépasse 7 et bien qu'il m'affiche 7.

et dans une autre cellule si le résultat et inferieur à 7( ex:41-42) et bien mètre 0 et si le résultat de ex: 45-42 et bien mettre 

2 Replies

I'm sorry the French translation is pretty bad but it sounds like you want to do a subtraction (I will give an example using A1-A2) but show a min of 0 and max of 7:
=MIN(7, MAX(0, A1 - A2))

or

=MEDIAN(0, 7, A1-A2)

ne fonctionne pas