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