Euro Convert Using Microsoft Excel 2007 Worksheet

Euro Convert Using Microsoft Excel 2007 Worksheet One of the new logical features included of the MS-Excel worksheets 2007 and 2010 called as euroconvert. Microsoft Office explain that, “Euroconvert is a logical formula that Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). The currencies available for conversion are those of European Union (EU) members that have adopted the euro. The function uses fixed conversion rates that are established by the EU”.

Just observe the post picture on the left. The first group of columns describes its currency of its members(European Union), the basic unit of currency, and the ISO Code. And the next group of columns describes its ISO code,calculation precession, and display precession. Where it is describes the currency specific rounding rules and how many decimal places Excel uses to calculate a currency's conversion and display the result. And the next group of columns are the amount, source, target, and include the equivalent for the value of the euro currency. Where the the syntax explain like this by the Microsoft office.

EUROCONVERT(number,source,target,full_precision,triangulation_precision)
Number   is the currency value you want to convert, or a reference to a cell containing the value.
Source   is a three-letter string, or reference to a cell containing the string, corresponding to the ISO code for the source currency. The following currency codes are available in the EUROCONVERT function:
Target   is a three-letter string, or cell reference, corresponding to the ISO code of the currency to which you want to convert the number. See the previous Source table for the ISO codes.
Full_precision   is a logical value (TRUE or FALSE), or an expression that evaluates to a value of TRUE or FALSE, that specifies how to display the result.
FALSEDisplay the result with the currency-specific rounding rules, see the table that follows. Excel uses the calculation precision value to calculate the result and the display precision value to display the result. FALSE is the default if the full_precision argument is omitted.
TRUEDisplay the result with all significant digits resulting from the calculation.
Triangulation_precision   is an integer equal to or greater than 3 that specifies the number of significant digits to be used for the intermediate euro value when converting between two euro member currencies. If you omit this argument, Excel does not round the intermediate euro value. If you include this argument when converting from a euro member currency to the euro, Excel calculates the intermediate euro value that could then be converted to a euro member currency.



  • Excel truncates any trailing zeros in the return value.



  • If the source ISO code is the same as the target ISO code, Excel returns the original value of the number.



  • Invalid parameters return #VALUE.



  • This function does not apply a number format.



  • This function cannot be used in array formulas.

  • But before any conversion begun check and install first the Euro Convert tool by following this instruction:
    1. Open your MS-Excel worksheets 2007 or 2010
    2. Once the worksheet open, click the office button on the top left side location
    3. Then point your mouse cursor to save as
    4. Then click Excel Options on the bottom under it
    5. Under the Excel Options Window click the Add-Ins under the left bar
    6. Then click the manage drop down bar located on the bottom
    7. Then select and click Excel Add-Ins
    8. Then click Go button
    9. Under the Add-Ins list window, check box “Euro Currency Tool”
    10. Then click Ok button
    11. Click Ok button for the next windows with the instruction
    12. Click ok button again
    13. Now you’re ready for your logical conversions for the Euro

    TIPS!


    • If you cannot install the excel Add-Ins just reinstall your Microsoft Office 2007 or 2010. If you have a license installer of this office version its better because you can download freely the Excel Add-Ins tools in Microsoft.com and create your Euro Convert worksheets and study it and learn it. Just follow this blog for next update. “End”

    Euro Convert Using Microsoft Excel 2007 Worksheet Arnel Cartoneros 5 of 5
    One of the new logical features included of the MS-Excel worksheets 2007 and 2010 called as euroconvert. Microsoft Office explain that, ...
    Share on Google Plus

    About Arnel Cartoneros

    Arnel is a Blog creator and writer, A founder and publisher of www.combinebasic.com and www.nuggetro.info. Part time Computer Instructor, Computer And Electronic Technician, And performing job as Biomedical Machine Specialist. I'm an avid fan of social media and very interested in Technical information and innovation.

      Blogger Comment
      Facebook Comment

    0 comments:

    Post a Comment

    If you have questions and comments pls. leave it here! You can post comments if you have google accounts. Thank you...