get currency format from a cell and convert it

[Andrea Maccaferri]

Hello,
I have to create an IF condition in order to change automatically a cell from $ to €.
How can I get a currency format from a cell?

at this moment I have created a column with a currency and use it to exchange but it isn't very sleek.

appreciate your help

[Limor_OP]

What is the condition?

It would be best if you upload a sample file, look at the yellow banner at the top of the page for instructions.

[Andrea Maccaferri]

please look in the attached columns F/G//H/I/J
I'd like to do G * F , if G is in € then has to divide by 1.20 (exchange EUR - USD).
Now I am doing it by the column H , but I think that is not the best way to do it

Thanks in advance

[JohnTopley]

What differnce is there between testing for "EUR" vs "€" (your test in J) ?

[Andrea Maccaferri]

I'd like to have all column J with currency € while in the column "I" I want the total based on the "real"currency.
if you see formula in J for having currency € I have inserted the column H

[JohnTopley]

If you are haapy to use VBA (UDF function):

Please Login or Register  to view this content.

then in J

=IF(currcode($G2)="€",$G2*$F2,IF(currcode($G2)="$",G2/$S$2*$F2,""))

so you no longer need column H

[JohnTopley]

Please Login or Register  to view this content.

then in J

=IF(currcode($G2)="€",$G2*$F2,IF(currcode($G2)="$",G2/$S$2*$F2,""))

so you no longer need column H

Reply on forum not behaving

[Andrea Maccaferri]

Many many thanks

I really admire your skills

[JohnTopley]

Well, I'll admit it, I found the code on the web but if it solves the problem ......!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.