+ Reply to Thread
Results 1 to 4 of 4

Showing only the value of the percentage calculation

  1. #1
    Registered User
    Join Date
    03-20-2016
    Location
    uk
    MS-Off Ver
    2013
    Posts
    1

    Showing only the value of the percentage calculation

    I want to be able to show only value of a % calculation in a table, how can i do this?

    For example if I have a £1000 and add 3% the formula =a2*1.03 will show the total of £1030, i just want it to show the working of the increase in the % but only show the £30.00 not the total as i want to be able to add it to a total later on in the table.

    Anyone know how to add the formula or if it can be done?

    Thanks

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Showing only the value of the percentage calculation

    maybe Add -A2 to the end of your formula
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Showing only the value of the percentage calculation

    Wouldn't it be:

    =A2*0.03
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Showing only the value of the percentage calculation

    DOH!! Dag-nab-it

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How can I avoid showing a large percentage value?
    By mcmuney in forum Excel General
    Replies: 2
    Last Post: 05-15-2015, 01:53 PM
  2. [SOLVED] Showing 2 cells as equal within a certain percentage
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2014, 03:34 PM
  3. Showing difference as a percentage
    By oliver79 in forum Excel General
    Replies: 1
    Last Post: 07-06-2010, 06:29 AM
  4. Showing a percentage of a percentage in pie chart
    By jimbob76 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-17-2009, 09:52 AM
  5. Percentage keeps showing 99 infront of it
    By wbleamas in forum Excel General
    Replies: 3
    Last Post: 07-01-2008, 03:47 AM
  6. Formula not showing the correct percentage...
    By Steve-B in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-03-2008, 11:27 AM
  7. [SOLVED] Using filters and showing columns as a percentage?
    By tox in forum Excel General
    Replies: 1
    Last Post: 02-27-2005, 08:06 PM

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