How do you get a 3 cell currency conversion formula to be editable?

Originally Posted by AliGW

Are you still using Excel 2010?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

OK, no, I am using Libre Calc as I have quite clearly stated in my original post (I originally wrote 'Libre Office' but I edited that out later). But a lot of Excel functions still can work with Libre Calc.

I don't see why I should upload a workbook since A) it would be from Libre Calc and B) It's a very simple straightforward question.

Imagine you have three cells that represent Currency Value A, Currency Value B and Exchange Rate. I want to have it so that if you change the value in one cell, it changes the value in one or both of the other cells IE a dynamic simple currency calculator. I just want to know if this were possible since the cells would contain formulas but would also be editable with a set value. Can something like this be done? Maybe something similar?

Thanks to anyone who can provide valuable input into my very simple request.

Cheers,
Paul
(mix_mash)

Is it possible to break this rule?

No.

You could look at using VBA though, but I have no idea about Libre Calc.

Libre Calc is basically the 'lite' (and free) version of Excel so it can do most of the things that Excel can do. I do think it is capable of VBA, though.

Thanks for the formula, Seabottom. I'm not sure what your formula does as it seems to add a fourth variable to something that only needs three. I do appreciate your help, anyway.

I was hoping to create a simple tool that would skip any unnecessary steps in the process but it looks like I'll have to do a manual set-up with three formulas and three manual inputs instead. Not the end of the world, though.

Again, much appreciated for the help.

Cheers,
Paul
(mix_mash)

What Seabottom's formula does is allow you to enter 2 of the 3 variables (in cells A2, B2, and C2) and the value of the one missing variable will show in cell D2. So if you enter the Currency Value A in A2, Currency Value B in B2, it will show the Exchange Rate in D2

If you enter Currency Value B in B2 and Exchange Rate in C2, the D2 will show the Currency Value A.

Ahh, I get it now. What a nifty little formula! Thanks. Seabottom.

And thanks for the explanation, Gregb11.

Cheers,
Paul
(mix_mash)