{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Home","Overview","Simple Arithmetic","Nested IF Formula","VLOOKUP Formula ","INDEX-MATCH Formula","Live Currency","Web Query","VBA","Change Default Curency","Live Currency Helper"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Currency Conversion in Excel"]
[]
[null,"Learn how to Convert Currency in Excel with this free workbook. Read the article we provided and practice these in the practice section."]
[]
[]
[null,"Prepared By","Md. Junaed-Ar-Rahman"]
[null,"Reviewed By","Aung Shine"]
[null,"Last Update","15/11/2023"]
[null,"Article Link","How to Convert Currency in Excel"]
[]
[null,"Examples"]
[]
[null,"1. Simple Arithmetic Formula to Convert Currency"]
[null,"2. Using Nested IF Formula for Currency Conversion"]
[null,"3. Using VLOOKUP to Convert Curency"]
[null,"4. INDEX-MATCH Formula to Convert Currency"]
[null,"5.Live Currency Conversion using Excel's Currency Converter"]
[null,"6. Currency Conversion Using Web Query"]
[null,"7. VBA Code to Convert Currency"]
[null,"8. Changing Default Currency"]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Overview","index":1,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,"Currency Conversion in Excel"]
[]
[null,"Simple Arithmetic Formula >>","Currency (USD)","Currency to Convert","Formula","Converted Currency",null,"Currency","Conversion Rate"]
[null,null,30,"EUR",{"$f":"_xlfn.FORMULATEXT(F4)","v":"=C4*I4"},{"$f":"C4*I4","v":27.900000000000002},null,"EUR",0.93]
[null,null,85,"GBP",{"$f":"_xlfn.FORMULATEXT(F5)","v":"=C5*I5"},{"$f":"C5*I5","v":68},null,"GBP",0.8]
[null,null,null,null,null,null,null,"AUD",1.5]
[null,"Nested IF Formula >>","Currency (USD)","Currency to Convert","Formula","Converted Currency",null,"CAD",1.34]
[null,null,30,"EUR",{"$f":"_xlfn.FORMULATEXT(F8)","v":"=IF(D$8=\"EUR\",I$4,IF(D$8=\"GBP\",I$5))*C8"},{"$f":"IF(D$8=\"EUR\",I$4,IF(D$8=\"GBP\",I$5))*C8","v":27.900000000000002},null,"CNY",7.11]
[null,null,85,"GBP",{"$f":"_xlfn.FORMULATEXT(F9)","v":"=IF(D9=\"EUR\",I$4,IF(D9=\"GBP\",I$5))*C9"},{"$f":"IF(D9=\"EUR\",I$4,IF(D9=\"GBP\",I$5))*C9","v":68},null,"INR",82.6]
[]
[null,"VLOOKUP Formula >>","Currency (USD)","Currency to Convert","Formula","Converted Currency"]
[null,null,30,"EUR",{"$f":"_xlfn.FORMULATEXT(F12)","v":"=VLOOKUP(D12,H$4:I$9,2,0)*C12"},{"$f":"VLOOKUP(D12,H$4:I$9,2,0)*C12","v":27.900000000000002}]
[null,null,85,"GBP",{"$f":"_xlfn.FORMULATEXT(F13)","v":"=VLOOKUP(D13,H$4:I$9,2,0)*C13"},{"$f":"VLOOKUP(D13,H$4:I$9,2,0)*C13","v":68}]
[]
[null,"INDEX-MATCH Formula >>","Currency (USD)","Currency to Convert","Formula","Converted Currency"]
[null,null,30,"EUR",{"$f":"_xlfn.FORMULATEXT(F16)","v":"=(INDEX(H$4:I$9,MATCH(D16,H$4:H$9,0),2))*C16"},{"$f":"(INDEX(H$4:I$9,MATCH(D16,H$4:H$9,0),2))*C16","v":27.900000000000002}]
[null,null,85,"GBP",{"$f":"_xlfn.FORMULATEXT(F17)","v":"=(INDEX(H$4:I$9,MATCH(D17,H$4:H$9,0),2))*C17"},{"$f":"(INDEX(H$4:I$9,MATCH(D17,H$4:H$9,0),2))*C17","v":68}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"Simple Arithmetic","index":2,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Currency Conversion in Excel",null,null,null,null,null,"Currency Conversion in Excel"]
[]
[null,"Using Simple Arithmetic Formula",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Currency","Conversion Rate",null,"Currency in USD","Converted to EUR",null,"Currency in USD","Convert To:"]
[null,"EUR",0.93,null,10,{"$f":"E7*C$7","v":9.3000000000000007},null,10]
[null,"GBP",0.8,null,55,{"$f":"E8*C$7","v":51.150000000000006},null,55]
[null,"AUD",1.5,null,30,{"$f":"E9*C$7","v":27.900000000000002},null,30]
[null,"CAD",1.34,null,85,{"$f":"E10*C$7","v":79.05},null,85]
[null,"CNY",7.11,null,98,{"$f":"E11*C$7","v":91.14},null,98]
[null,"INR",82.6,null,95.66,{"$f":"E12*C$7","v":88.963800000000006},null,95.66]
[null,"BZR",4.92,null,105,{"$f":"E13*C$7","v":97.65},null,105]
[null,"ZAR",19.23,null,120,{"$f":"E14*C$7","v":111.60000000000001},null,120]
[null,null,null,null,null,null,null,130.25]
[null,null,null,null,null,null,null,141.96]
[null,null,null,null,null,null,null,200]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"Nested IF Formula","index":3,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Currency Conversion in Excel",null,null,null,null,null,null,"Currency Conversion in Excel"]
[]
[null,"Using Nested IF Formula",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Currency (USD)","Currency to Convert","Converted Currency",null,null,null,null,"Currency (USD)","Currency to Convert","Converted Currency"]
[null,10,"USD",{"$f":"IF(C6=\"USD\",C$28,IF(C6=\"EUR\",C$18,IF(C6=\"GBP\",C$19,\nIF(C6=\"INR\",C$23,IF(C6=\"CAD\",C$21,IF(C6=\"JPY\",C$27))))))*B6","v":10},null,null,null,null,10,"USD"]
[null,10,"EUR",9.3000000000000007,null,null,null,null,10,"EUR"]
[null,10,"GBP",8,null,null,null,null,10,"GBP"]
[null,10,"INR",826,null,null,null,null,10,"INR"]
[null,10,"CAD",13.4,null,null,null,null,10,"CAD"]
[null,10,"JPY",1277.7,null,null,null,null,10,"JPY"]
[null,105,"EUR",97.65,null,null,null,null,105,"EUR"]
[null,120,"GBP",96,null,null,null,null,120,"GBP"]
[null,130.25,"INR",10758.65,null,null,null,null,130.25,"INR"]
[null,141.96,"USD",141.96,null,null,null,null,141.96,"USD"]
[]
[null,"Currency","Conversion Rate"]
[null,"EUR",0.93]
[null,"GBP",0.8]
[null,"AUD",1.5]
[null,"CAD",1.34]
[null,"CNY",7.11]
[null,"INR",82.6]
[null,"BZR",4.92]
[null,"ZAR",19.23]
[null,"HKD",7.84]
[null,"JPY",127.77]
[null,"USD",1]
[]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"VLOOKUP Formula ","index":4,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Currency Conversion in Excel",null,null,null,null,null,null,null,null,null,"Currency Conversion in Excel"]
[]
[null,"Using VLOOKUP Formula",null,null,null,null,null,null,null,null,null,"Practice yourself"]
[]
[null,"Currency","Conversion Rate",null,"Amount (USD)",{"$f":"\"Convert to \" & F7","v":"Convert to CAD"},"Converted Currency",null,null,null,null,"Currency","Conversion Rate",null,"Amount(USD)",{"$f":"\"Convert to \" & P7","v":"Convert to "},"Converted Currency"]
[null,"EUR",0.93,null,160,"CAD",{"$f":"VLOOKUP(F7,B7:C15,2,0)*E7","v":214.4},null,null,null,null,"EUR",0.93,null,50]
[null,"GBP",0.8,null,null,null,null,null,null,null,null,"GBP",0.8]
[null,"AUD",1.5,null,null,null,null,null,null,null,null,"AUD",1.5]
[null,"CAD",1.34,null,null,null,null,null,null,null,null,"CAD",1.34]
[null,"CNY",7.11,null,null,null,null,null,null,null,null,"CNY",7.11]
[null,"INR",82.6,null,null,null,null,null,null,null,null,"INR",82.6]
[null,"BZR",4.92,null,null,null,null,null,null,null,null,"BZR",4.92]
[null,"ZAR",19.23,null,null,null,null,null,null,null,null,"ZAR",19.23]
[null,"HKD",7.84,null,null,null,null,null,null,null,null,"HKD",7.84]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"INDEX-MATCH Formula","index":5,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Currency Conversion in Excel",null,null,null,null,null,null,null,null,"Currency Conversion in Excel"]
[]
[null,"Using INDEX-MATCH Formula",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Currency","Conversion Rate",null,"Amount (USD)",{"$f":"\"Convert to \"&F7","v":"Convert to CAD"},"Converted Currency",null,null,null,"Currency","Conversion Rate",null,"Amount(USD)",{"$f":"\"Convert to \"&O7","v":"Convert to "},"Converted Currency"]
[null,"EUR",0.93,null,50,"CAD",{"$f":"(INDEX(B7:C15,MATCH(F7,B7:B15,0),2))*E7","v":67},null,null,null,"EUR",0.93,null,50]
[null,"GBP",0.8,null,null,null,null,null,null,null,"GBP",0.8]
[null,"AUD",1.5,null,null,null,null,null,null,null,"AUD",1.5]
[null,"CAD",1.34,null,null,null,null,null,null,null,"CAD",1.34]
[null,"CNY",7.11,null,null,null,null,null,null,null,"CNY",7.11]
[null,"INR",82.6,null,null,null,null,null,null,null,"INR",82.6]
[null,"BZR",4.92,null,null,null,null,null,null,null,"BZR",4.92]
[null,"ZAR",19.23,null,null,null,null,null,null,null,"ZAR",19.23]
[null,"HKD",7.84,null,null,null,null,null,null,null,"HKD",7.84]
[]
[]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"Live Currency","index":6,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null," Currency Conversion in Excel",null,null,null,null,null," Currency Conversion in Excel"]
[]
[null,"Using Live Currency Converter",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Amount","Currency Conversion Pair","Price","Converted Currency",null,null,"Amount","Currency Conversion Pair","Exchange Ratio","Converted Amount"]
[null,30,{"$error":"#VALUE!"},{"$f":"_FV(Table10[[#This Row],[Currency Conversion Pair]],\"Price\")","v":0.91069999999999995},{"$f":"Table10[[#This Row],[Amount]]*Table10[[#This Row],[Price]]","v":27.320999999999998},null,null,30,{"$error":"#VALUE!"}]
[null,11,{"$error":"#VALUE!"},{"$f":"_FV(Table10[[#This Row],[Currency Conversion Pair]],\"Price\")","v":0.78820000000000001},{"$f":"Table10[[#This Row],[Amount]]*Table10[[#This Row],[Price]]","v":8.6701999999999995},null,null,11,{"$error":"#VALUE!"}]
[null,24,{"$error":"#VALUE!"},{"$f":"_FV(Table10[[#This Row],[Currency Conversion Pair]],\"Price\")","v":1.5107999999999999},{"$f":"Table10[[#This Row],[Amount]]*Table10[[#This Row],[Price]]","v":36.2592},null,null,24,{"$error":"#VALUE!"}]
[null,84,{"$error":"#VALUE!"},{"$f":"_FV(Table10[[#This Row],[Currency Conversion Pair]],\"Price\")","v":1.357},{"$f":"Table10[[#This Row],[Amount]]*Table10[[#This Row],[Price]]","v":113.988},null,null,84,{"$error":"#VALUE!"}]
[null,57,{"$error":"#VALUE!"},{"$f":"_FV(Table10[[#This Row],[Currency Conversion Pair]],\"Price\")","v":7.1273999999999997},{"$f":"Table10[[#This Row],[Amount]]*Table10[[#This Row],[Price]]","v":406.26179999999999},null,null,57,{"$error":"#VALUE!"}]
[null,77,{"$error":"#VALUE!"},{"$f":"_FV(Table10[[#This Row],[Currency Conversion Pair]],\"Price\")","v":83.283000000000001},{"$f":"Table10[[#This Row],[Amount]]*Table10[[#This Row],[Price]]","v":6412.7910000000002},null,null,77,{"$error":"#VALUE!"}]
[null,85,{"$error":"#VALUE!"},{"$f":"_FV(Table10[[#This Row],[Currency Conversion Pair]],\"Price\")","v":0.91069999999999995},{"$f":"Table10[[#This Row],[Amount]]*Table10[[#This Row],[Price]]","v":77.409499999999994},null,null,85,{"$error":"#VALUE!"}]
[null,97,{"$error":"#VALUE!"},{"$f":"_FV(Table10[[#This Row],[Currency Conversion Pair]],\"Price\")","v":18.501300000000001},{"$f":"Table10[[#This Row],[Amount]]*Table10[[#This Row],[Price]]","v":1794.6261},null,null,97,{"$error":"#VALUE!"}]
[null,98,{"$error":"#VALUE!"},{"$f":"_FV(Table10[[#This Row],[Currency Conversion Pair]],\"Price\")","v":7.8021000000000003},{"$f":"Table10[[#This Row],[Amount]]*Table10[[#This Row],[Price]]","v":764.60580000000004},null,null,98,{"$error":"#VALUE!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"Web Query","index":7,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Currency Conversion in Excel"]
[]
[null,"Using Web Query"]
[]
[null,"Amount (USD)"," Currency to Convert","Conversion Rate","Converted Currency",null,null,null,null,null,"Practice Yourself"]
[null,15,"Euro",{"$f":"VLOOKUP(Table7[[#This Row],[ Currency to Convert]],Table_1[],2,0)","v":0.917381},{"$f":"Table7[[#This Row],[Amount (USD)]]*Table7[[#This Row],[Conversion Rate]]","v":13.760714999999999},null,"US Dollar▲","1.00 USD▲▼","inv. 1.00 USD▲▼"]
[null,11,"British Pound",{"$f":"VLOOKUP(Table7[[#This Row],[ Currency to Convert]],Table_1[],2,0)","v":0.80252699999999999},{"$f":"Table7[[#This Row],[Amount (USD)]]*Table7[[#This Row],[Conversion Rate]]","v":8.8277970000000003},null,"Argentine Peso",353.97499900000003,2.8249999999999998E-3,null,"Amount"," Currency to Convert","Exchange Ratio","Converted Amount "]
[null,24,"Australian Dollar",{"$f":"VLOOKUP(Table7[[#This Row],[ Currency to Convert]],Table_1[],2,0)","v":1.5384150000000001},{"$f":"Table7[[#This Row],[Amount (USD)]]*Table7[[#This Row],[Conversion Rate]]","v":36.921959999999999},null,"Australian Dollar",1.5384150000000001,0.65002000000000004,null,15,"Euro"]
[null,84,"Canadian Dollar",{"$f":"VLOOKUP(Table7[[#This Row],[ Currency to Convert]],Table_1[],2,0)","v":1.372028},{"$f":"Table7[[#This Row],[Amount (USD)]]*Table7[[#This Row],[Conversion Rate]]","v":115.25035200000001},null,"Bahraini Dinar",0.376,2.6595740000000001,null,11,"British Pound"]
[null,57,"Chinese Yuan Renminbi",{"$f":"VLOOKUP(Table7[[#This Row],[ Currency to Convert]],Table_1[],2,0)","v":7.203328},{"$f":"Table7[[#This Row],[Amount (USD)]]*Table7[[#This Row],[Conversion Rate]]","v":410.589696},null,"Botswana Pula",13.444558000000001,7.4380000000000002E-2,null,24,"Australian Dollar"]
[null,77,"Indian Rupee",{"$f":"VLOOKUP(Table7[[#This Row],[ Currency to Convert]],Table_1[],2,0)","v":83.287824000000001},{"$f":"Table7[[#This Row],[Amount (USD)]]*Table7[[#This Row],[Conversion Rate]]","v":6413.162448},null,"Brazilian Real",4.8994410000000004,0.20410500000000001,null,84,"Canadian Dollar"]
[null,85,"Brazilian Real",{"$f":"VLOOKUP(Table7[[#This Row],[ Currency to Convert]],Table_1[],2,0)","v":4.8994410000000004},{"$f":"Table7[[#This Row],[Amount (USD)]]*Table7[[#This Row],[Conversion Rate]]","v":416.45248500000002},null,"British Pound",0.80252699999999999,1.2460640000000001,null,57,"Chinese Yuan Renminbi"]
[null,95,"South African Rand",{"$f":"VLOOKUP(Table7[[#This Row],[ Currency to Convert]],Table_1[],2,0)","v":18.364965000000002},{"$f":"Table7[[#This Row],[Amount (USD)]]*Table7[[#This Row],[Conversion Rate]]","v":1744.6716750000001},null,"Bruneian Dollar",1.3434219999999999,0.74436800000000003,null,77,"Indian Rupee"]
[null,98,"Hong Kong Dollar",{"$f":"VLOOKUP(Table7[[#This Row],[ Currency to Convert]],Table_1[],2,0)","v":7.7958790000000002},{"$f":"Table7[[#This Row],[Amount (USD)]]*Table7[[#This Row],[Conversion Rate]]","v":763.99614200000008},null,"Bulgarian Lev",1.7942400000000001,0.55733900000000003,null,85,"Brazilian Real"]
[null,null,null,null,null,null,"Canadian Dollar",1.372028,0.72884800000000005,null,95,"South African Rand"]
[null,null,null,null,null,null,"Chilean Peso",883.31321000000003,1.132E-3,null,98,"Hong Kong Dollar"]
[null,null,null,null,null,null,"Chinese Yuan Renminbi",7.203328,0.138825]
[null,null,null,null,null,null,"Colombian Peso",4068.0723589999998,2.4600000000000002E-4]
[null,null,null,null,null,null,"Czech Koruna",22.445571999999999,4.4552000000000001E-2]
[null,null,null,null,null,null,"Danish Krone",6.832147,0.146367]
[null,null,null,null,null,null,"Emirati Dirham",3.6724999999999999,0.27229399999999998]
[null,null,null,null,null,null,"Euro",0.917381,1.09006]
[null,null,null,null,null,null,"Hong Kong Dollar",7.7958790000000002,0.128273]
[null,null,null,null,null,null,"Hungarian Forint",347.37492200000003,2.879E-3]
[null,null,null,null,null,null,"Icelandic Krona",140.88645399999999,7.0980000000000001E-3]
[null,null,null,null,null,null,"Indian Rupee",83.287824000000001,1.2007E-2]
[null,null,null,null,null,null,"Indonesian Rupiah",15549.544599000001,6.3999999999999997E-5]
[null,null,null,null,null,null,"Iranian Rial",42002.667673000004,2.4000000000000001E-5]
[null,null,null,null,null,null,"Israeli Shekel",3.7231169999999998,0.268592]
[null,null,null,null,null,null,"Japanese Yen",149.53353200000001,6.6870000000000002E-3]
[null,null,null,null,null,null,"Kazakhstani Tenge",461.25228099999998,2.1679999999999998E-3]
[null,null,null,null,null,null,"Kuwaiti Dinar",0.308313,3.2434620000000001]
[null,null,null,null,null,null,"Libyan Dinar",4.8436310000000002,0.206457]
[null,null,null,null,null,null,"Malaysian Ringgit",4.6794669999999998,0.2137]
[null,null,null,null,null,null,"Mauritian Rupee",44.159889999999997,2.2644999999999998E-2]
[null,null,null,null,null,null,"Mexican Peso",17.225021999999999,5.8055000000000002E-2]
[null,null,null,null,null,null,"Nepalese Rupee",133.32298499999999,7.5009999999999999E-3]
[null,null,null,null,null,null,"New Zealand Dollar",1.66933,0.59904299999999999]
[null,null,null,null,null,null,"Norwegian Krone",10.794394,9.2641000000000001E-2]
[null,null,null,null,null,null,"Omani Rial",0.38502999999999998,2.5972029999999999]
[null,null,null,null,null,null,"Pakistani Rupee",287.02745599999997,3.4840000000000001E-3]
[null,null,null,null,null,null,"Philippine Peso",55.559240000000003,1.7999000000000001E-2]
[null,null,null,null,null,null,"Polish Zloty",4.0179650000000002,0.24888199999999999]
[null,null,null,null,null,null,"Qatari Riyal",3.64,0.274725]
[null,null,null,null,null,null,"Romanian New Leu",4.5657740000000002,0.21902099999999999]
[null,null,null,null,null,null,"Russian Ruble",89.820009999999996,1.1133000000000001E-2]
[null,null,null,null,null,null,"Saudi Arabian Riyal",3.75,0.26666699999999999]
[null,null,null,null,null,null,"Singapore Dollar",1.3434219999999999,0.74436800000000003]
[null,null,null,null,null,null,"South African Rand",18.364965000000002,5.4452E-2]
[null,null,null,null,null,null,"South Korean Won",1295.4476649999999,7.7200000000000001E-4]
[null,null,null,null,null,null,"Sri Lankan Rupee",328.13112799999999,3.0479999999999999E-3]
[null,null,null,null,null,null,"Swedish Krona",10.591676,9.4413999999999998E-2]
[null,null,null,null,null,null,"Swiss Franc",0.88583100000000004,1.128884]
[null,null,null,null,null,null,"Taiwan New Dollar",31.775673000000001,3.1470999999999999E-2]
[null,null,null,null,null,null,"Thai Baht",35.168331000000002,2.8434999999999998E-2]
[null,null,null,null,null,null,"Trinidadian Dollar",6.7640770000000003,0.14784]
[null,null,null,null,null,null,"Turkish Lira",28.694704000000002,3.4849999999999999E-2]
[null,null,null,null,null,null,"Venezuelan Bolivar",3534709.5364020001,0]

{"sheet":"VBA","index":8,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Currency Conversion in Excel"]
[]
[null,"Using VBA Code"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"Change Default Curency","index":9,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Currency Conversion in Excel"]
[]
[null,"Changing Default Currency"]
[]
[null,"Currency","Conversion Rate",null,"Amount (USD)",{"$f":"\"Convert to \" & F7","v":"Convert to INR"},"Converted Currency"]
[null,"EUR",0.93,null,160,"INR",{"$f":"VLOOKUP(F7,B7:C13,2,0)*E7","v":13216}]
[null,"GBP",0.8]
[null,"AUD",1.5]
[null,"CAD",1.34]
[null,"CNY",7.11]
[null,"INR",82.6]
[null,"BZR",4.92]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"Live Currency Helper","index":10,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[null," Currency Conversion in Excel"]
[]
[null,"Using Live Currency Converter"]
[]
[null,"Amount","Currency Conversion Pair"]
[null,30,"USD/EUR"]
[null,11,"USD/GBP"]
[null,24,"USD/AUD"]
[null,84,"USD/CAD"]
[null,57,"USD/CNY"]
[null,77,"USD/INR"]
[null,85,"USD/EUR"]
[null,97,"USD/ZAR"]
[null,98,"USD/HKD"]