Excel get percentage of difference between numbers

Question

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.

Answer 1

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.