Solved

excel 2010 help

Posted on 2012-03-26
1
183 Views
Last Modified: 2012-04-04
i am trying to convert currency.

in cell a2 i have us dolloars and i need to convert into in Indian rupees. can someone help me out please.
0
Comment
Question by:romeiovasu
1 Comment
 
LVL 13

Accepted Solution

by:
Ashok earned 500 total points
ID: 37767026
if rate = 50.75 (and you type it in K1 cell, then use K2 = A2 * K1)

otherwise, you can just hard-code it

K2 = A2 * 50.75
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now