View Single Post
  #2   Report Post  
goober
 
Posts: n/a
Default Percentage difference calc that knows the largest figure


=IF(A1A2,(A1-A2)/A1,(A2-A1)/A2)

This should help you.

Good Luck.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=483896