I have two columns, one for USD price and EUR price. I want these prices to automatically be converted to DKK (Danish crowns), so:
USD price*6.51 = DKK price
EUR price*7.44 = DKK price
So, if there is a value in the USD price column, this value gets multiplied by 6.51 and the result is displayed in the DKK price column. If there is no value under USD, then it takes the EUR price instead.