LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DGunn
 
Posts: n/a
Default Excel formulas, comparing numbers

comparison of numbers over 4 years for % change.
02 03 04 05:

99 55 74 60
1 0 3 4
392 96 71 71
0 2 5 0

with "zero" receiving /div as result.
using formula =(b2-a2)/abs(a2)

Thx in advance for your help.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? C-Man23 Excel Worksheet Functions 3 January 19th 06 09:52 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? C-Man23 Excel Worksheet Functions 1 January 9th 06 01:23 PM
Comparing tables in excel with formulas TotallyConfused Excel Discussion (Misc queries) 1 December 18th 05 03:10 AM
Does Excel round numbers with a 5 in the tens place? Ian Elliott Excel Discussion (Misc queries) 1 May 24th 05 11:35 PM


All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"