Forum Discussion
Calculating Two Cells Based on each other
If you have two cells, one for CAD and another for USD, you can't use each of them both as source and as result, at least working with formulas only. You need source CAD, source USD (to enter data); result CAD and result USD (calculated by formulas) plus one cell for exchange rate.
SergeiBaklan Yes I have gotten that far. I can write the formulas to perform the calculations one way or the other but then you lose the formulas depending on where you enter the original number. I have been reading that I may need to use VBA to achieve this. This is outside of my knowledge and have been attempting to find solutions online that I can duplicate.
Maybe one simple way to do this, without VBA, is via a dropdown box that asks for either CAD or USD, after which you enter the amount, and there's an IF formula that changes the direction of the conversion from CAD to USD or vice versa.
I was just in Canada and recall the exchange rate as somewhere around 1.3 CAD to 1 USD, so that's the factor I put in, but it can be easily changed. Here's what the screen looks like.
Yes, that's only with VBA - it's also not my territory.
SergeiBaklan Okay thanks for trying.
