# How to change the value of a cell depending on another cell

Options
✭✭

I have a task, on a dropping list I have 3 row, each row according a value in another cell which should be change, example:

Dropping list on a b9 cell contains value a1,a2,a3

In a cell e9 I want to input automatically 10, 20 or 30, if

a1=10, b2=20, a3=30

• Overachievers Alumni
Options

I'm having a little trouble following your description. Could you post any screenshots to show what you're trying to do?

• ✭✭
Options

I'm trying to make cell E9 dependent of cell B9. If I select 1 of the 3 options from the dropdown in cell B9, I want to change the input in cell E9 automatically.

• Overachievers Alumni
Options

Gotcha. You're looking for an IF formula. In the cell you want to be dependant you would write something like:

=IF(B@row = A1, 10, IF(B@row = 20, 20, 30))

• ✭✭
Options

Seems like it's not working.

I have 3 options in a dropping list in a cell B9: L28, L79, L639. If I choose smth it should input data in a cell E9. L29 = 116\$, L79 = 77, L 639 = 130. Following your example I got:

• Overachievers Alumni
Options

Are you trying to enter this formula in Excel? If so, it is a different syntax. I was assuming you were showing me the project in Excel and trying to replicate it in Smartsheet.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!