Converting all displaying values to other currencies

Hi,
I have made a personal budget document with all data in UK pounds, but I would also very much like to see the data in Swedish currency (and not just the total, but every field).
I could ofcourse copy every field to the side and *13,5 but that would be quite messy.
Is there anyway I could make a checkbox which said Currency with 2 options (UK pounds, Swedish 13,5) and if you put it to swedish every field would be times 13,5?

A vauge plan for it is to maybe make a userdefined function to and put every single field through it (like CurrencyThing(x)) and that function would look at the checkbox to see if to multiply it or not.
But that would mean I have to have that function through everything, plus I would have to learn how to make that function, does anyone know a better way?

Hi,

A very quick solution is to replicate your whole worksheet in a second worsksheet where in cell A1, you go typing
=Sheet1!A1*13,5
and then copy this formula right left as needed ...

HTH
Carim

Hmm thanks but that's not really the solution I'm looking for, it's a bit too messy.

the best solution yet I've come up with is to have 2 checkboxes, if the UK one is selected A1 = 1 if Swedish is selected A1 = 2,
then a second field A2 has the formula if A1 = 1 then 1, if A1 = 2 then 13,5.
So then every calculation in the rest of the document I have *Sheet1!A2.
So atleast now I don't have to do any User function, but I still have to make it *Sheet1!A2 on every field tho.

Ok then if you have your solution ... why ask ...!!!

Your solution will work ... you only have to type in If 's in each cell ...

HTH
Carim

I don't have to type in IF in each cell, just in one, but I have to multiply each cell with that.

The reason why I asked was because I had hoped there were a better solution, maybe a built-in Currency thing that you could change, I've never used Excel before so I don't know,

As you wish ...

But adding an If or a multiplication to each and every cell means :
a manual intervention on each celll ...!!!

Carim

VBA Noob,

You are absolutely right ... (as usual ..)

With an event macro, Target.Address=A1 showing the currency selected by the user ... it is feasible AND it is an elegant solution, provided our user is prepared to maintain, preferably on a separate sheet, all the exchanges rates needed to convert his "cable"-based original worksheet ...

Cheers
Carim

I don't understand what you mean :S

Ah thanks, that sounds much better than the solution I'm currently using