| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need formula to get % between 2 numbers
I have 2 fields where I'm trying to show not only a difference but also a
percentage, whether < or . Any help? thanks |
|
#2
|
|||
|
|||
|
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. ---- Regards, John Mansfield http://www.pdbook.com "NM" wrote: I have 2 fields where I'm trying to show not only a difference but also a percentage, whether < or . Any help? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Row Numbers in Formula with Macro | Excel Discussion (Misc queries) | |||
| Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
| How to add 4 of 5 highest numbers using a formula | Excel Discussion (Misc queries) | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Linear Mode
