View Single Post
  #4   Report Post  
Mighty Magpie
 
Posts: n/a
Default Percentage difference calc that knows the largest figure

Many thanks for that - it works fine

Cheers


"Mighty Magpie" <mighty.magpie@home wrote in message
...
Thanks for the info and prompt response - I am grateful


"goober" wrote in
message ...

=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