Mutual exclusive currency cells

[macgywer]

Hi!

I'm trying to use two columns mutually exclusive for data input. In the first column the user can enter the value in USD and in the second column in EUR. The other member automatically adjusts to the first data entered depending on exchange rate. Any idea how I can accomplish that?
__[A]_________[B]_________[C]
1_[Value USD]_[Value EUR]__[Exchange rate]
2_[1]_________[0,704]______[1,42]
3_[1,42]_______[1]
4…
…

[royUK]

You need a formula to convert the currency, if you type into a cell with a formula you overwrite the formula.

[macgywer]

Thanks royUK but the currency calculation isn’t my problem. Let’s say 1 need the value of A2 or A3 further in the calculation. The problem is that I don’t know if the user is going to enter the value in A2 as USD or in A3 as EUR. I guess I need a macro to determine which value is entered last and update the second. Any idea how I can solve that?