+ Reply to Thread
Results 1 to 2 of 2

Find percentage of a value compared to another value in Excel .

  1. #1
    Registered User
    Join Date
    04-18-2021
    Location
    France
    MS-Off Ver
    2016
    Posts
    1

    Find percentage of a value compared to another value in Excel .

    Hi guys this is an extreme noob question, so i have two cells each cell contains a volume value and i want to see how much a volume represents in comparison of the other one in percentage, for example we have volume 1 and volume 2 i want to find how much valume 2 represents compared to volume 1 in percentages and the result should be like volume 2 is representing 60% of volume 1, like if we took volume 2 and put it inside volume 1 it will fill up 60% of the volume 1, i hope i made sense, i tried using this formula but im not sure it's correct (=(A3-A2)/A2 )

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,483

    Re: Find percentage of a value compared to another value in Excel .

    You simply need. =A3/A2 if A3 is 60 and A2 = 100 then you get 60/100 which comes down to 60%

+ 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. Replies: 4
    Last Post: 10-19-2017, 08:12 AM
  2. [SOLVED] Excel 2013 - How to find data compared two dates
    By Zyrusi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2017, 11:52 AM
  3. Percentage of Top seller compared to new item
    By mlopez60120 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2017, 09:43 AM
  4. Compared Cell in multiple column and find min
    By robert12345 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2015, 09:11 PM
  5. Replies: 1
    Last Post: 04-30-2014, 05:49 PM
  6. Symphony software functionality compared to Excel
    By w31kn1 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-20-2009, 03:27 PM
  7. [SOLVED] how do i find percentage from 2 different pages in Excel?
    By fpbuckland in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2005, 11:06 PM

Tags for this Thread

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