Forum Discussion
Calculating Two Cells Based on each other
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.
It would help if you use one cell for exchange rate and antherone as entry cell
Then use the third one as a resul cell, bu in the result cell you can treat the entry as USD and CAD after concatenate them with &
So you get the both result in the same cell
I hope it helps. I meant to ask you what the context was here? What process is this all a part of, in other words? Because sergei's first suggestion was also reasonable, I thought. What I did was simply make it possible for a single input and single output cell to do the job. The user would just need to be specifying which currency you're starting with....but presumably that would not be changing every time....
- I'm building budgets that can have elements in 2 currencies. Now i understand that you can always just move everything to one currency which is simple and the more traditional path. That's very simple....
I need the spreadsheet to handle either USD to CAD inputs and provide me with both USD and CAD outputs....and seeing both is important to discussion. So if i can in make column A CAD create B USD or vice versa it would solve my problem without having to create a worksheet. But I need it to not erase the formula everytime. I need the formula to not exist in the cell itself....
