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 -
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
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
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
=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
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