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 691 views

## 1 answer to this question.

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.
• 23,260 points

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

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

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

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

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

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

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

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

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

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

## Convert Rows to Columns with values in Excel using custom format

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

## IF - ELSE IF - ELSE Structure in Excel

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