Formula for Converting the Currency Dollars to Euros

Posted on April 1, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Yesterday we talked about a formula to calculate the price reduction or discount and today were sticking with the dollar formulas.

 

If you are considering advertising on one of my blogs or requesting a product or blog review, this might be an important one for you :) . I’m thinking of changing the advertising value to Euros instead of Dollars.

 

So dear clients, pay attention!!

 

To convert the currency from Dollars to Euros in Excel you’ll need to take the following steps.

 

I’m starting out with the same data that I used in the article with a formula to calculate the price reduction or discount.

 

Formula-Converting-Currency-Dollars-Euros-pic1

 

·         Select Cells C5:C10

·         And type in =B5*$C$1

 

Formula-Converting-Currency-Dollars-Euros-pic2

 

·         Press CTRL+ENTER

·         And click on the Accounting Format Button.

·         And select Euros.

 

Formula-Converting-Currency-Dollars-Euros-pic3

 

·         And now you should have a beautiful looking sheet with two currency columns.

 

Formula-Converting-Currency-Dollars-Euros-pic4

 

And if you want to convert Euros back to Dollars you should type in the formula =C5/$C$1.

 

I have for you tomorrow another cool and useful Outlook trick and FYI If you want to advertise or order a blog or product review, the prices are still in dollars and the prices aren’t going up this month. I’m working on some big projects and I didn’t had the time to adjust the advertising pages, so if you are looking for a bargain be quick;)!! Ill see you all tomorrow, cheers!!

 

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

5 Responses to “Formula for Converting the Currency Dollars to Euros”

  1. nadine on September 29th, 2008 4:01 pm

    Hi there,

    i followed your complete instructions, but its not working at all. I get VALUE! as a result could you explain me what i might have done wrong??

    thank you very much

  2. Vincent on September 29th, 2008 5:44 pm

    Hi Nadine,

    I’m now not home but I’ll check it for you as soon as I get home, it should work.

    gr.

    Vincent

  3. Mir Ahmad on March 12th, 2009 8:20 am

    hello

    i dont know how to make a good expence sheet

    to show expences in doler , euro , Afghani
    and sapreted them too

    regards

  4. Vincent on March 13th, 2009 2:23 am

    You need to give us some more details, we can not explain much with this information

  5. Wes on April 15th, 2009 6:11 pm

    Amazing! Great formula. Thanks for the FREE information. Other websites wanted to charge $19.99 for this same info.

Leave a Reply