# How can i change the formula of a column when an element from a list in another column is selected

Hello, how can i change the formula of a column when an element from a list in another column is selected ?

For exemple in column 1 i have a list 1,2,3 and in column 3 i have the formula (column 2 * 10)
Now i want that when i select 2 in the list of column 1 the formula in column 3 change for (column 2* 20)

Hi @Maxime_Montoya !

Without a sample doc it’s a little bit hard to see what you want to do here … but if I get this right, you want to multiply the value in you `column 2` by `10 * the value in your select list` ?

So, if you choose `3` in your select list, the formula should do something like :

``````Column 2 * 30
``````

If yes, I think you could just use a formula such as :

``````column 2 * column 1 * 10
``````

Which should reflect that if:

``````Column 1 = 1 -> 1 * 10  => 10   ==> Column 2 * 10
Column 1 = 2 -> 2 * 10  => 20   ==> Column 2 * 20
Column 1 = 3 -> 3 * 10  => 30   ==> Column 2 * 30
``````

Now, if I’m completely wrong, could you share a sample doc with us so we could help you find the appropriate solution ? This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.