need formula to get % between 2 numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 fields where I'm trying to show not only a difference but also a
percentage, whether < or >.

Any help?

thanks
 
NM,

Assume you have data in cells A1 and B1. To find the percentage difference
between the two numbers, using B1 as the base the formula is:

( A1 - B1 ) / ABS (B1)

ABS is Excel's absolute value function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

difference in numbers displayed as a +/- percentage 3
If between 2 numbers, multiply 5
How to subtract a number from a Mergefield? 0
percentages 2
Percentages between two cells 1
Get percentage of whole 2
Count based on 2 conditions 4
Problem with excel. Please Help!! 0

Back
Top