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, 2022 in Others by gaurav
• 23,260 points
599 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, 2022 by gaurav
• 23,260 points

Related Questions In Others

0 votes
1 answer

Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

answered Feb 11, 2023 in Others by Kithuzzz
• 38,010 points
848 views
0 votes
1 answer

Why does difference between same dates shows a difference of 1 month in Excel?

That's because you formatted the output using ...READ MORE

answered Mar 24, 2023 in Others by Kithuzzz
• 38,010 points
411 views
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, 2022 in Others by narikkadan
• 63,700 points
551 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, 2022 in Others by narikkadan
• 63,700 points
2,290 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, 2022 in Others by Edureka
• 13,670 points
2,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, 2022 in Others by Edureka
• 13,670 points
1,636 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, 2022 in Others by Edureka
• 13,670 points
797 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,831 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, 2022 in Others by gaurav
• 23,260 points
498 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, 2022 in Others by gaurav
• 23,260 points
1,426 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