Just to let you all know I managed to work it out
I nested my formula using the following: -
=IF(A2B2,"X",IF(A2<B2,"Y", IF(A2=B2,"Z")))
--
recklaw
------------------------------------------------------------------------
recklaw's Profile:
http://www.excelforum.com/member.php...o&userid=32469
View this thread:
http://www.excelforum.com/showthread...hreadid=522572