Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Differences Uniformly
Hi, I have a list of numbers: 2 -4 3 3 -45 -32 etc I know from looking at the list the difference between the numbers is: -6 7 0 -48 7 But I can't figure out what a short sweet formula is to calculate the difference on the way down. If I say "A2-B1" and they are both negative numbers it'll add them both as positive numbers instead of showing the net change between the two numbers. If one is negative and the other is positive, if I subtract the negative it turns positive on me, which makes me, well, get pretty negative, lol Any thoughts on this would be much appreciated TIA! -- tx12345 ------------------------------------------------------------------------ tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776 View this thread: http://www.excelforum.com/showthread...hreadid=497105 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Differences Uniformly
Assuming the numbers are in column A starting in cell A1, then in cell B2 use A2 - A1, and copy down. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=497105 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating differences in dates | Excel Discussion (Misc queries) | |||
calculating time/dates differences | Excel Discussion (Misc queries) | |||
Calculating differences between dates | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |