View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
recklaw
 
Posts: n/a
Default Complicated formula help required


Just wanted to thank everyone.

=INT(12-ABS(x-y)/2)*(ABS(x-y)<24) worked a treat

Just need to go and understand it now ;o)


--
recklaw
------------------------------------------------------------------------
recklaw's Profile: http://www.excelforum.com/member.php...o&userid=32469
View this thread: http://www.excelforum.com/showthread...hreadid=524494