(513) 874-3306
We fix and repair laptop motherboard no video, no...
Answer
where can I get a customer tool disk for a sharp xa-a41s??
Problem for Programming Tools
Generic problem for all Programming Tools
Excel Formula
By sambentech on Jan 11, 2008
Require formula to convert $usd to £gbp on excel spreadsheet
Comments:
Jan 11, 2008
- Need to convert currency rateJan 11, 2008
- Thanks for that.Is products we sell and are 2k in total all priced in USD.
Had formula before but lost it, know when 1st one done you can highlight cell and put cursor in bottom right and corner and drag all way down the columns required.
Will try out your suggestion
Same Problem
Mar 11, 2009
- i havve no microsot office professional edition 2003 - GuestSolution #1
posted on Jan 11, 2008
Hello,
Do you mean convert to the current currency rate? like you have 1$ in the cell and you want it to show .70 £
or do you mean to change the symbol? from $ to £
let me know,
Chester
=(B1*.51)
=(what this cell will equal), () to initiate a formula, B1 (being the cell of the number you want to use, in your case the US dollar), * (means multiply), .51(todays conversion rate)
with .51 being the current conversion rate. There are also ways to hide rows in Excel if you didnt want to show the dollars at all.
Additionally the above formula can be simply copied and pasted for each column, so you don't have to type: =(B2*.51), =(B3*.51)
If you are confused by this formula or still need help let me know.
Regards,
Chester
Do you mean convert to the current currency rate? like you have 1$ in the cell and you want it to show .70 £
or do you mean to change the symbol? from $ to £
let me know,
Chester
Comments:
Jan 11, 2008
- Well I am not a super expert, but if it were my problem, I would put all of the numbers for the US dollars in one row say for instance B or XX and then for where I wanted to put the pounds I would type a formula into the cell... if D was the row for the pounds and B was the row for the dollars I would write;=(B1*.51)
=(what this cell will equal), () to initiate a formula, B1 (being the cell of the number you want to use, in your case the US dollar), * (means multiply), .51(todays conversion rate)
with .51 being the current conversion rate. There are also ways to hide rows in Excel if you didnt want to show the dollars at all.
Additionally the above formula can be simply copied and pasted for each column, so you don't have to type: =(B2*.51), =(B3*.51)
If you are confused by this formula or still need help let me know.
Regards,
Chester
Yes
No
This Problem Also Relates To:
Intel C++ Compiler for Linux 8.1 for Linux
Intel Fortran Linux Compiler Version 8.0 (ftc080lsgb001) for PC
Microsoft Visual Basic Enterprise Edition 6.0 (361-00667) for PC
Microsoft ASP.NET Programming with MS Visual C# .NET
Microsoft Ae Visual Sudio Tools for Office 2003 (u74-00114) for PC
Microsoft ACAD MSDN Universal (534-02868-3) for PC
Microsoft Visual Studio .NET Professional 2003 for PC
Popular Solutions for Programming Tools
Questions and Unsolved Problems for Programming Tools
Answer
it's not working full screen in vista
Answer
I have problem related to toad as OCI version 10.2.0.1.0 is not supported plz clearify this problem
Answer
I have downloaded matlab but when I try to run it it comes up with ''error starting desktop''
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Programming Tools:
Top Programming Tool Experts
Experience:
I have owned a computer networking sales and service company.
Ask Me
Top Computer & Laptop Repair
