跳到主要內容

如何在Excel中快速在美元,英鎊,歐元之間轉換?

例如,您有一個表格,其中列出了一些以美元表示的收入和支出,而您想將它們轉換為歐元或英鎊,反之亦然。 您將採用哪些方式? 有幾個簡單的選項可幫助您解決此問題:

使用匯率在美元,英鎊和歐元之間轉換貨幣

使用Kutools for Excel在美元,英鎊和歐元之間轉換貨幣

一個例子可能很容易理解。 假設您有以下美元,現在我們將指導您將美元轉換為歐元和英鎊。

DOC-美元兌歐元-1


箭頭藍色右氣泡 使用匯率在美元,英鎊和歐元之間轉換貨幣

最常見的方法是找出兩種貨幣之間的匯率。 以將美元轉換為歐元為例,您可以執行以下步驟:

1。 搜索美元和歐元之間的匯率,當前匯率為 1美元= 0.726089歐元 目前。

2。 在單元格B2中輸入公式 = A2 * 0.726089,然後按 Enter 鍵。

DOC-美元兌歐元-2

3。 單擊單元格B2,然後拖動“填充手柄” 將此公式複製到B3:B10。 然後,您將在B列中獲得所有以歐元計的錢。

DOC-美元兌歐元-3

4。 您也可以通過這種方式輕鬆地將美元轉換為英鎊,將英鎊轉換為歐元,將英鎊轉換為美元,將歐元轉換為英鎊,並將歐元轉換為美元。


箭頭藍色右氣泡 使用Kutools for Excel在美元,英鎊和歐元之間轉換貨幣

每次需要兌換貨幣時都搜索匯率無聊嗎? 貨幣太多了,這些貨幣之間的匯率一直在變化。 很難得到匯率。 請不要擔心 Excel的Kutools's 貨幣兌換 工具可以幫助您獲取任何一種貨幣之間的最新匯率,並幫助您在它們之間快速轉換。

Excel的Kutools 包括300多個便捷的Excel工具。 30天免費試用,不受限制。 立即獲取.

步驟 1:點擊 庫工具 > 內容轉換器 > 貨幣兌換。 看截圖:

DOC-美元兌歐元-4

步驟 2:選擇您要轉換貨幣的範圍,然後在 貨幣兌換 對話框中,指定設置如下:

  • 選擇來源貨幣 美元 從左側列錶框中,然後選擇貨幣 EURO 您想從右側列錶框中進行轉換;
  • 點擊 更新率 按鈕以獲取最新匯率。

DOC-美元兌歐元-5

第一步: 然後點擊 填充選項 按鈕,在 填充選項 提示框,選擇所需的一種輸出類型,然後關閉框以返回到 貨幣兌換 對話框,請參見屏幕截圖:

DOC-美元兌歐元-6

步驟 4:指定輸出類型後,然後單擊 OK or 登記 按鈕,您將獲得以下結果:

(1.)如果選擇 只有細胞 作為輸出類型,所有新轉換的貨幣值都將替換原始值,請參見屏幕截圖:

DOC-美元兌歐元-7 -2 DOC-美元兌歐元-8

(2.)如果選擇 僅評論 作為輸出類型,所有轉換後的值和一些詳細信息將作為註釋插入到原始單元格中。 看截圖:

DOC-美元兌歐元-9

(3.)如果選擇 單元格和評論 作為輸出結果,轉換後的值將被填充到原始單元格中,詳細信息也將作為註釋插入。 看截圖:

DOC-美元兌歐元-10

Excel的Kutools's 貨幣兌換 使用可靠的Internet網站上的最新匯率,您可以使用這些工具快速地在Excel中轉換50多種貨幣。 您可以使用當前匯率輕鬆地從範圍單元格轉換單個值或體積值。 點擊了解更多…


相關文章:

如何在Microsoft Excel中轉換貨幣?

最佳辦公生產力工具

熱門特色: 尋找、突出顯示或識別重複項   |  刪除空白行   |  合併列或儲存格而不遺失數據   |   沒有公式的回合 ...
超級查詢: 多條件VLookup    多值VLookup  |   跨多個工作表的 VLookup   |   模糊查詢 ....
高級下拉列表: 快速建立下拉列表   |  依賴下拉列表   |  多選下拉列表 ....
欄目經理: 新增特定數量的列  |  移動列  |  切換隱藏列的可見性狀態  |  比較範圍和列 ...
特色功能: 網格焦點   |  設計圖   |   大方程式酒吧    工作簿和工作表管理器   |  資源庫 (自動文字)   |  日期選擇器   |  合併工作表   |  加密/解密單元格    按清單發送電子郵件   |  超級濾鏡   |   特殊過濾器 (過濾粗體/斜體/刪除線...)...
前 15 個工具集12 文本 工具 (添加文本, 刪除字符,...)   |   50+ 圖表 類型 (甘特圖,...)   |   40+ 實用 公式 (根據生日計算年齡,...)   |   19 插入 工具 (插入二維碼, 從路徑插入圖片,...)   |   12 轉化 工具 (數字到單詞, 貨幣兌換,...)   |   7 合併與拆分 工具 (高級合併行, 分裂細胞,...)   |   ... 和更多

使用 Kutools for Excel 增強您的 Excel 技能,體驗前所未有的效率。 Kutools for Excel 提供了 300 多種進階功能來提高生產力並節省時間。  點擊此處獲取您最需要的功能...

kte選項卡201905


Office選項卡為Office帶來了選項卡式界面,使您的工作更加輕鬆

  • 在Word,Excel,PowerPoint中啟用選項卡式編輯和閱讀,發布者,Access,Visio和Project。
  • 在同一窗口的新選項卡中而不是在新窗口中打開並創建多個文檔。
  • 將您的工作效率提高 50%,每天為您減少數百次鼠標點擊!
Comments (6)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
AFFORDABLE/COMFORTABLE LOAN OFFER WITHOUT COST/STRESS CONTACT US VIA Call/Text +1(415)630-7138 Email



Do you find yourself in a bit of trouble with unpaid bills and don’t know which way to go or where to turn? What about finding a reputable Debt Consolidation firm that can assist you in reducing monthly installment so that you will have affordable repayment options as well as room to breathe when it comes to the end of the month and bills need to get paid? BENJAMIN LOAN INVESTMENTS FINANCE is the solution to your financial misfortune. We offer all types of loan ranging from $5,000.00 to $533,000,000.00USD with a low interest rate of 2% and loan duration of 1 to 35 years to pay back the loan secure and unsecured. Our loans are well insured for maximum security is our priority, Our leading goal is to help you get the services you deserve, Our program is the quickest way to get what you need in a snap. Kindly reduce your payments to ease the strain on your monthly expenses by Contacting us on the following Call/Text +1(415)630-7138 Email



Loan Offer Alert For Everyone! Are you financially down and you need an urgent credit/financial assistance? Or are you in need of a loan to start-up/increase your business or buy your dream house. GET YOUR INSTANT LOAN APPROVAL 100% GUARANTEED TODAY NO MATTER YOUR CREDIT SCORE.
This comment was minimized by the moderator on the site
I Am Mrs Lucy, I give out affordable loan at 3% interest rate. contact us at: with Your Full Name, Amount Needed, Loan Duration, Country, Mobile No.SENT VIA EMAIL US:
This comment was minimized by the moderator on the site
This is very nice post. It is also very helpful for us.I have been searching types of tutorial because i love exchange .some days ago I read an article about exchange . but this post this better than post.
This comment was minimized by the moderator on the site
Dear sir/Madam, We can help you with a loan today, I want you to contact us if interested. Take an Immediate decision and contact us in our Home Office were loan transactions are process and transfer within the shortest possible period. Personal Loan Business Loan Car Loan Debt consolidation Loans First Name: Surname: Gender: Country: state: Occupation: Contact phone number: Loan amount needed: Loan Duration: Purpose of loan: Monthly Income / Yearly Income: IF interested Fill immediately and return. Regards Amo Global Funding
This comment was minimized by the moderator on the site
you looking for a mortgage? Looking for a quick loan or a funding firm for a business deal, contact us today at Atlas-loan company for a loan or investment funding from $5,000.00 to $100,000,000.00. **Personal Loan (Secure and Unsecured) **Business Loan (Secure and Unsecured) **Car Loan (Secure and Unsecured) **Debt consolidation Loans (Secure and Unsecured) () Best Regards, Amo-loan company
This comment was minimized by the moderator on the site
Do you have a version that works on a MacBookPro operating system?
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations