Hi there,
I would like to calculate 2 different currencies.
1 column contains price column of virtual currency (V$) and other column contains euro (€).
1 euro = 0,45 V$
Table:
Product name Price (V$) Price (€)
--------------------------------------------------
Awesome product 4 1,8
I would like to have calculations in both of the column cells respective to eachother.
So if i enter V$ price (example 4 V$) into the V$ column row then it multiplies the same value with 0,45 and the "Price €" column should return 1,8 eur.
Also the other way around... if i enter price in euro to "Price €" column then it divides the price and returns answer into V$ value.
Can we use macro somehow to calculate those prices in the same field where i put the value?
I attached the excel file.
Bookmarks