Excel get percentage of difference between numbers

0 votes

I'm trying to figure out how to add an equation in a cell which will give me the percentage of a number the difference between two numbers is. For example:

Cell A1: 154
Cell B1: 150

If I use this equation: 150 - 154, the answer is -4. What I need is an equation to give me what percentage of Cell A1 is Cell B1 - Cell A1. If that makes sense.

I've tried B1-A1/A1*100 and it gives me 50, but it's clearly not 50%.

I know it seems simple, but I can't seem to make it work for some reason.

Thanks.

Nov 7 in Others by gaurav
• 22,040 points
30 views

1 answer to this question.

0 votes

Find the percentage of change between two numbers

  1. Click any blank cell.
  2. Type =(2500-2342)/2342, and then press RETURN . The result is 0.06746.
  3. Select the cell that contains the result from step 2.
  4. On the Home tab, click . The result is 6.75%, which is the percentage of increase in earnings.
answered Nov 8 by gaurav
• 22,040 points

Related Questions In Others

0 votes
1 answer

How to get rid of a #value error in Excel?

Changing the format to "Number" doesn't actually ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
73 views
0 votes
1 answer

How to get sum of all matches of HLOOKUP in Excel?

Consider: =SUMPRODUCT((A1:E1="apple")*(A2:E2)) To include more ...READ MORE

answered Oct 16 in Others by narikkadan
• 37,660 points
60 views
0 votes
1 answer

Get column names of Excel worksheet with OpenPyXL in readonly mode

This will print every thing from row ...READ MORE

answered Oct 22 in Others by narikkadan
• 37,660 points
238 views
0 votes
1 answer

Get number of columns of a particular row in given excel using Java

Use: int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); Or int noOfColumns = sh.getRow(0).getLastCellNum(); There ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
105 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
137 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
230 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
101 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
68 views
0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

answered Nov 8 in Others by gaurav
• 22,040 points
29 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
506 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP