Question about Computers & Internet

1 Answer

Excel Formula Require formula to convert $usd to £gbp on excel spreadsheet

Posted by on

  • 1 more comment 
  • sambentech Jan 11, 2008

    Need to convert currency rate

  • sambentech Jan 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

  • Anonymous Mar 11, 2009

    i havve no microsot office professional edition 2003

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 32 Answers

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

Posted on Jan 11, 2008

  • Chester Gould
    Chester Gould 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


×

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

In an Excel Spreadsheet, A1 contains date and I need A2 to be yellow if the date falls in the month of May


it is all in the formula setting at the top
download the excel user manual and any excel problems are explained in that document

May 26, 2017 | The Computers & Internet

1 Answer

Do you have a formula in Microsoft Excel that a value can convert to a word...(Ex. 15,000 then it will convert to in words fifteen Thousand..)thanks. need immediate reply.


Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

  1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
  2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
  3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
  4. Then, press Alt+Q to close the Visual Basic Editor window.
  5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
  6. Then, save the Excel Sheet.
eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.


Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook

2 Answers

What is the function of Microsoft excel?


Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

Formula


check this link it will help you to learn excel

http://people.usd.edu/~bwjames/tut/excel/

dont forget to rate ^^

Jun 08, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

What is formula new excell


I certainly can't take the time to explain v lookup to you in this forum, but I can direct you to several sites that you can familiarize yourself with it. It's going to take you time to to understand it.

http://spreadsheets.about.com/b/2008/03/17/excel-vlookup-3.htm

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

http://www.techonthenet.com/excel/formulas/vlookup.php

Jun 21, 2009 | Microsoft Computers & Internet

1 Answer

Excel Real-Time


  1. open ur spreadsheet from your files that you want to insert a dynamic date and time
  2. select the cell into which you want to insert the dynamic date and time.
  3. Type "=now()" (ignore quotation marks) into the selected cell.
  4. Press the "Enter" key on your keyboard to enter the formula into the selected cell. You will now see the current date and time appear in the cell you typed the formula into. (Date and time will update every time the "Enter" key is pressed )
.

Feb 17, 2009 | Microsoft Computers & Internet

1 Answer

Countifs


The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.
=countif(A1:B9,1)

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Need Formula


TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

4 Answers

I want the excel compound interest formula


=10000*(1+0.96)^12
=10000*(1+0.10)^18
=10000*(1+0.10)^24

Dec 02, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

229 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...