SOLVED

ERREUR FORMULE

%3CLINGO-SUB%20id%3D%22lingo-sub-2219630%22%20slang%3D%22fr-FR%22%3EFORMULA%20ERROR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2219630%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EHere's%20my%20problem%3A%3C%2FP%3E%3CP%3Efrom%20a%20cell%20where%20a%20weight%20is%20indicated%2C%20I%20have%20to%20calculate%20in%20another%20cell%20the%20density%20that%20varies%20according%20to%204%20weight%20intervals%3A%20%26lt%3B1.6kg%20densit%C3%A9%20%3D%2019.7%2Fpoids%3C%2FP%3E%3CP%3Ebetween%201.6%20and%203kg%20density%20-%2024.6%2F%20weight%3C%2FP%3E%3CP%3E3%20to%205kgdensity%20-%2034.2%2Fweight%3C%2FP%3E%3CP%3Eand%20%26gt%3B%20at%205kg%20density%20-%2037.4%2Fweight%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20in%20my%20weight%20cell%20is%20rated%202.4kg%2C%20I%20would%20like%20my%20cell%20to%20display%20density%3C%2FP%3E%3CP%3E24.6%2F2.4%20s%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2219630%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Bonjour

Voilà mon problème :

à partir d'une cellule où un poids est indiqué, je dois calculer dans une autres cellule la densité qui varie selon 4 intervalles de poids : <1.6kg densité = 19.7/poids

                                              compris entre 1.6 et 3kg densité = 24.6/ poids

                                               de 3 à 5kgdensité = 34.2/poids

                                                et > à 5kg densité = 37.4/poids

 

Par exemple, si dans ma cellule de poids est noté 2.4kg, je voudrai que dans ma cellule densité il affiche

24.6/2.4 s

2 Replies
best response confirmed by CAPAGOU26 (New Contributor)
Solution

@CAPAGOU26 

Disons que le poids est dans cellule A2. La formule serait:

 

=LOOKUP(A2,{0,1.6,3,5},{19.7,24.6,34.2,37.4})/A2

 

ou en français:

 

=RECHERCHE(A2,{0,1.6,3,5},{19.7,24.6,34.2,37.4})/A2

@Hans VogelaarMerci beaucoup Hans pour votre aide.

Bravo