+ Reply to Thread
Results 1 to 2 of 2

Applying percentage calculator to table

  1. #1
    Registered User
    Join Date
    12-03-2005
    Posts
    1

    Applying percentage calculator to table

    Hi ............

    Grateful of any help to change a table of figures in one currency to another by
    applying a percentage calculator, eg Pounds sterling to US Dollars by mutiplying
    all figures in all cells by 1.73.

    I can create the formula to make the change, but can't seem to apply it to the
    figures in the individual cells.

    Thanks for any help.

    Joe

  2. #2
    Niek Otten
    Guest

    Re: Applying percentage calculator to table

    In an empty cell, enter the number 1.73.
    Edit>Copy
    Select your table of figures.
    Edit>Paste special, check Multiply

    --
    Kind regards,

    Niek Otten

    "Manicjoe" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hi ............
    >
    > Grateful of any help to change a table of figures in one currency to
    > another by
    > applying a percentage calculator, eg Pounds sterling to US Dollars by
    > mutiplying
    > all figures in all cells by 1.73.
    >
    > I can create the formula to make the change, but can't seem to apply
    > it to the
    > figures in the individual cells.
    >
    > Thanks for any help.
    >
    > Joe
    >
    >
    > --
    > Manicjoe
    > ------------------------------------------------------------------------
    > Manicjoe's Profile:
    > http://www.excelforum.com/member.php...o&userid=29325
    > View this thread: http://www.excelforum.com/showthread...hreadid=490422
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1