Forum Discussion

oliviermouaze's avatar
oliviermouaze
Copper Contributor
Dec 02, 2021
Solved

Formules et fonction avec champ de nom

Bonjour J'ai plusieurs fichiers excel ou j'ai plusieurs constante et plusieurs variable j'ai associé un nom au cellule ayant des constantes du coup mes cellules F4, G4, H4 s'appelle gravité, magnet...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Dec 02, 2021

    oliviermouaze 

    =IFERROR(IF(E8/(C8*D8)=Gravity,"gravity",IF(E8/(C8*D8)=Magnet,"magnet",IF(E8/(C8*D8)=Force,"force"))),"")

     

    Maybe like this? I entered above formula in B8 and copied down to B20.

    If you enter =C13*D13*Magnet  in cell E13 along with values in cell C13 and D13 the formula returns "magnet" in B13. 

    I attributed named ranges Gravity, Magnet and Force for cells C5, D5 and E5.

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 02, 2021

    oliviermouaze 

    =IFERROR(IF(E8/(C8*D8)=Gravity,"gravity",IF(E8/(C8*D8)=Magnet,"magnet",IF(E8/(C8*D8)=Force,"force"))),"")

     

    Maybe like this? I entered above formula in B8 and copied down to B20.

    If you enter =C13*D13*Magnet  in cell E13 along with values in cell C13 and D13 the formula returns "magnet" in B13. 

    I attributed named ranges Gravity, Magnet and Force for cells C5, D5 and E5.

    • oliviermouaze's avatar
      oliviermouaze
      Copper Contributor
      Dec 02, 2021
      Thanks a lot