How to create a dependence of one cell on the value in another?

Question

Google Sheets

Hello.
There is a conditional column with the price of the product, as well as a conditional column with its availability. With the help of data validation, in the "Availability" column, I made a drop-down list in front of each cell with a price with the values ​​"Yes" and "No". I want the price of the product to change depending on the choice of any value from the list. For example, when you select "Yes" in the list, the price of the product will change to 0. Tell me, how can this be done?

Answer 1

In the price column, write the "if" formula.
For example, for the first line "=IF(B2 = "Yes", 0, "r.5 500")"