Free Microsoft Excel 2013 Quick Reference

Currency conversion US$ in Indian rupees

iHi Guys,

I have a database with me which has currencies in US$ format as follows:

USA - 1,124,594 (US Dollar thousand)

Now I have to convert this value in 2 formats:

1. Indian Rupees
2. US$ Million (for example - 1.00 millions, up to 2 decimal points)

Now I want to go forward tot his as follows:

1. first I want to convert the value in words so that it can be read and understood by anyone in the team.

2. I want the conversion in Indian rupee and US$ as stated in point number 2 above.

Any help will be greatly appreciated!


how do i change the currency unit from US $ to Indian Rupees in the expense statement or loan calculator when I insert sheets from the spread sheet solutions.
1.open excel
2.Get page Sheet 1,2,3 etc
3.click insert youget general and spread sheet solution
4.Select expense statement

Now how to convert the $ there to Indian Rupees

Thanks in advance
Cafes

Hello All.

I have a spreadsheet with data, whose data elements includes price of parts and the appropriate currency values. I would like to have a new column which would have all the net price in USD. The thing is the data of issue of these orders are over 3 years and each period has a different conversion rate. Is there a way by which I can make the conversion according to the appropriate conversion rates in the respective periods of time?

Thanks.

Dear Excel gurus of the world,
I have a currency conversion problem which I'm sure there's a simple solution to:
B1 contains the US exchange rate in Australian dollars which happens to be .56
B2 contains the Euro exchange rate to Aussie dollars which is also about .56 These cells are variable with the exchange rate. Elsewhere in my worksheet say G40 I want to enter my contract price in US or Euro and have it autonatically convert to Aus Dollars in that very same cell. How is this done ?
Cheers,
Chris, Melbourne Australia.

How do i define a number format in excel for Indian Rupees. I didnt find it
in the drop down menu list in the numbers format.

This may be a bit long, but here it is:
I need help setting up a sheet with travel expenses incurred in different
countries. These expenses will be converted into Swiss Francs (CHF) and US
Dollars (USD). Columns A through E contain codes and descriptions. Column G displays USD converted values and column H, Swiss Franc, or CHF, converted values. Individual amounts are entered EITHER in column K (for Euro values),OR L (for pound - GBP values), OR in a column M for "floating" currencies, which can vary depending on what country was visited, Sweden or Russia, for example... Columns I and J repeat the Swiss franc and dollar values respectively.

Currently H2:H7 contain currency rates for the following: GBP =1CHF; 1 $= SEK; 1 $= GBP; 1 $ = CHF; 1 $ = €; 1CHF=€; which are used as absolute reference cell addresses as the placeholders for conversion rates that are updated periodically for inclusion in formulas that will be in G 10 and H10 going down with every new expense entered.

The conversion itself is simple, my question is how do I write a formula in G10 and H 10 that will allow the secretary to enter an amount, say in L10 for pounds and have the formula in G10 and H10 check that there are no values in I10, J10, and M10 and then convert the pound amount in L10 by the corresponding conversion value in H4 (in this case) for The USD in pounds. Alternatively, if an entry is made into M11 for Russian Rubles, for example, it would check that the other cells K11 and L11 don't have any values and therefore it will know to divide it s amount by the corresponding value of the ruble in H2:H7. I thought this might be achieved with If statements checking for null values. or a variation of an IF statement. Did I make this too complex? It's what we need unfortunately.

The primary objective is to have a secretary input ONLY the updated currency rates in H2:H7 and the varying amounts in K10, OR 10, OR M10 and additional rows down and have these values automatically converted by the formula in G and H to be added up at the end of all entries.

I appreciate anything you can say that will help or guide me in the right direction.

Renetrainer

Customising a TEXT(Value,"Format") for Indain Currency

I use a particular format for displaying numeric values as money in Indian Rupees with appropriate commas after Thousands and Lakhs..

I have the following two formats to be used in the FORMAT CELL for the Numeric values where Money or Currency has to be displayed..

1. [>9999999]"Rs "#,##,##,##0;[>99999]"Rs "#,##,##0;"Rs "#,##0 without dedimal points.
Ex:- 125999 -->> Rs 1,25,999

2. [>9999999]"Rs "#,##,##,##0.00;[>99999]"Rs "#,##,##0.00;"Rs "#,##0.00 with decimal points upto 2 decimal places...Ex:- 125999 -->> Rs 1,25,999.00

Now this works fantastically for numeric entries, however I need to use the same format when using in a sentence such as Rs 1,25,999 for the XYZ expense..

So how do I customise the same in the TEXT Function..?

What FORMAT do I use in the TEXT Functions parameter to get the same result using it in a sentence..

Regards
e4excel

hi
is there any macro available to spell number in indian currency
i have one addin but its not giving words for "zero value"
please give suggestions

thnks& regds

Hello All.

I have a spreadsheet with data, whose data elements includes price of parts and the appropriate currency values. I would like to have a new column which would have all the net price in USD. The thing is the data of issue of these orders are over 3 years and each period has a different conversion rate. Is there a way by which I can make the conversion according to the appropriate conversion rates in the respective periods of time?

Thanks.

Hi!

I have a small table with formatted currency conversions that is fetched from a datasource online.

I would like to create a custom function that I can use in worksheets to convert a value from one currency to another. I figured the function would look something like this:

	VB:
	
=Currency_Convert([Value];[Curr_in];[Curr_out]) 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Value = Value to be converted
Curr_in = Currency the value is in (i.e USD)
Curr_out = Currency to convert value to (i.e SEK)

I was thinking that the function would work in 2 steps:
1. Look up curr_in and match it with the "Y-axis" in the table and the curr_out would match the X-axis to get the correct conversion rate.
2. multiply the value with found rate.

The table looks like this:

Could someone help me with this, or point me in the right direction? I don't know where to start...

Hi,

I wonder if there is a function similar to MSNStockQuote or the Euro
Conversion Tool that converts US$ to GBP and is updated via the web

Hi All,

I have been spinning around in circles trying to make a workable solution to this - I am sure the Excel experts out there will know how.

I have a starting number of say £50,000. This is the opening balance. I want to show this in Euros and US $ too. Easy enough with a simple formula.

Now I want to show a running balance as debits come off the opening balance - leaving a running total.

However, the debits can be in three currencies - Euro, US $ and Sterling.

So I want the spreadsheet to calculate the balance regardless of which currency is being debited from the opening balance.

So if the o/b is £50,000 - and a payment of $10,000 is made - I want the result to be £43,806.52 in the running total.

$10,000 converted to Sterling at 1.6146 exchange rate giving £6193.48 and then deducted from the total.

Simple enough - but the debit could be one of three currencies - which is where I am struggling.

Any help or suggestions would be great.

Hi Folks,
after converting the currency into US $ I'm getting the result like 1.225.00
Is there anyway to convert the first decimal into coma so that it can look like 1,225.00
Any help will be appreciated
Thank you

I am using Office 2000. My problem is that I want to display a number in
Indian style. For e.g. a number such as 158276185 is displayed as
15,82,76,185 in the Indian accounting system. The option given in Excel will
format the above number as 158,276,185. I tried a custom number format
(##","##","##","##0) which resolved the issue but created problems if the
number of digits are less. For e.g. a number such as 185 would be displayed
as ,,,185 (i.e. three commas were prefixed to the number while the same were
not required). I would be grateful if a solution is provided for the above
issue.

Thanks
Victor

Plz explain how to put commas in Indian style (Not Million style).
Eg: 1,24,51,248.00

I have found the below mentioned formula to custom format numbers in Indian comma style of crore, lakhs, thousands. The formula does not provide desired results for negatives. Also I am in need of mentioning the negatives in paranthesis i.e negative no. of 1 crore as (1,00,00,000.00). Please give the solution to the above.

[>9999999]##,##,##,##0.00;[>99999]##,##,##0.00;##,##0.00

Please provide detailed solution since I have only basic knowledge in excel and have not dealt with macros programming.

Dear Friends,

Can anyone tell me how can i format numbers like : 1,00,00,000 for One Crore
In indian number style insted of : 10,000,000

Pls reply

Regards,
Mahesh

Currency Conversion example.xlsx

How do I auto calc the green cells?

Basically I have set up a data query from the MSN money website (Columns D-F) and have some amounts formatted as currencies and want to convert them to GBP amounts based on the appropriate currency conversion rate.

Need some sort of lookup into the table but I don't know how to lookup based on currency formats?

Thanks

I am designing invoice format for my business. I would like to convert the grand total amount in figures (in Indian Rupees) to Text and display the same in a predetermined cell automatically. For ex: Rs. 2,20,200.25 should be converted to "Rupees Two Lakhs Twenty Thousand Two Hundred and Paise Twenty Five Only." Is there any option in Excel 2007 to facilitate this, which I am unaware of? Can somebody enlighten me?

hi,

spellnumber fuction in excel is for getting figures in text in english ie.
100000.00 formula converts it in its text "One Hundred Thousand Dollars
but I want to get it converted in Indian rupee how to do it. Is there any
different formula to convert a number into its text in Indian Rupee, If its
there kindly help me for the same.

Regards,
Aarif

can anyone tell me the function how to convert numbers in words in Indian rupees in excel using formula. (without macro) . Just like presently excel 2002 have =bathtext() but it will convert in Thai language.

Please see attached excel file.
I am trying to make a formula on E17.

I am hoping that I can convert D17 to USD on given number C17.

hi,

spellnumber fuction in excel is for getting figures in text in english ie.
100000.00 formula converts it in its text "One Hundred Thousand Dollars
but I want to get it converted in Indian rupee how to do it. Is there any
different formula to convert a number into its text in Indian Rupee, If its
there kindly help me for the same.

Regards,
Aarif

I have workbook named News.xls with 3 sheets namely Pricelist, Muster and
Bill for the month of January, 2005.
Muster contains presenty of each client, marked P for present & A for Absent
A.....B.....C.....D.....
Days Sun Mon Tue Wed
Date 1 2 3 4
1 John P A A P
2 Lucy A P P A
3

Pricelist contains prices for news papers (amount in Indian Rupees)
A.....B.....C.....D.......E.........F.......G.......H...
Days Sun Mon Tue Wed Thu Fri Sat

Times 5 4 4 4 4 4 3.50

Economic 9 2 2 2 2 2 9

Now I want to prepare bills in sheet "Bill". I want Excel to check first
from Muster whether client is marked as "P" on 1st of Jan, 05 (Saturday), if
so, he should take a price of Times newspaper for Saturday from sheet
Pricelist i.e. Rs.5/-, if not, put 0.00, & so on.. Thus my sheet will show :

A.....B.....C.....D.....E.......F......G.......H......I..Total
Days Sat Sun Mon Tue Wed Thu Fri Sat
Date 1 2 3 4

1 John 4 5 4 4 4 0 0 4 25.oo

Note : On Thu & Fri John was marked as "A"
How can I perform this in sheet Bill.

--
Knowldege is Power

In a cross border world with investors sitting in multiple jurisdictions, assessing investment opportunities in emerging or submerging markets, often requires managers or underwriters to convert the local or native currency into a currency that the analyst is comfortable with. This gives the analyst a better “feel” of the risk in question.
Similarly, MNCs that have operations in different countries often require accountants sitting in different countries send their spread sheets in two or more currencies. Atleast, important rations and analysis.
Examples like these are more common than expected and vital in countries where Financial Statements need to be read in besides the US$.
The Euro Tool is partial answer; regrettably it restricts itself to Euro Currencies only. The other restriction which accentuates my problem if one needs to see results in another currency, one needs to select cells, convert those cells into a currency of choice and the display those results in destination cells. For currencies other than Euro Zone one has to do a similar operation using the conversion ratio as the index cell.

1. Do you know if there an add-in available that can REPLACE my (i) selected cells, indeed my (ii_) entire worksheet or (iii) workbook by another currency(s), converted from the native currency and importantly vice versa by selecting them from a drop down menu? If an add-in is not available, can it be done in Excel?

2. I sit in India, where # 1 is very relevant; compounding this problem is the Indian concept of Lakhs and Crores. Indians place there commas behind the zeros very different to the rest of the world. For example 1,000,000 (Million) is 10, 00,000 Lakhs. 100,000,000 (100 million/billion) is 10, 00, 00,000 Crores. In addition to the currency replacement problem as stated in #1, for the Indian Rupee, the commas have to be repositioned as well!

If anyone knows a way to address these questions, I think the accounting community would be grateful for those inputs.
Best,