+ Reply to Thread
Results 1 to 2 of 2

Increase a value by a % with result showing in original cell?

  1. #1
    ASmith
    Guest

    Increase a value by a % with result showing in original cell?

    Is there a way to increase a value in a cell by a percentage and have the
    result show in the same cell as the original value? I'm trying to apply a 4%
    increase to some prices and would rather not calculate each value but instead
    apply a formula to change the cells across the board. Thanks!


  2. #2
    Bob Phillips
    Guest

    Re: Increase a value by a % with result showing in original cell?

    In a separate cell enter 104%

    Then select all cells to change
    Goto Edit>Pastespecial, click Multiply, and OK

    Then clear the 104%

    --

    HTH

    Bob Phillips

    (replace xxxx in the email address with gmail if mailing direct)

    "ASmith" <[email protected]> wrote in message
    news:[email protected]...
    > Is there a way to increase a value in a cell by a percentage and have the
    > result show in the same cell as the original value? I'm trying to apply a

    4%
    > increase to some prices and would rather not calculate each value but

    instead
    > apply a formula to change the cells across the board. Thanks!
    >




+ 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