View original (French)

Change a cell's value based on another one.

Solved
Gantoine62 Posted messages 206 Registration date   Status Member Last intervention   -  
Zoul67 Posted messages 2001 Status Member -
Hello,
I would like that when a number changes in one cell, the value changes in another cell. For example, in G24 when the number is = 1, in J24 the value will be 50; when the number is = 2, the value will be 55; when the number is = 3, the value will be 70.
I look forward to hearing from you
Best regards

Configuration: Windows / Chrome 72.0.3626.121

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    let there be a series of conditions:

    =IF(G24=1,50,IF(G24=2,55,IF(G24=3,70)))

    or if there are many more conditions, with a reference table, for example to adapt
    • from Y1 to Y20 the values of G24
    • from Z1 to Z20, in rows the corresponding J values
    • and in J24 the formula:

    =IFERROR(VLOOKUP(G24,$Y$1:$Z$20,2,0),"")

    the IFERROR(formula),"") code leaving a blank cell if G24 does not contain a value from Y1:Y20
    best regards

    1