Assuming A1:B5 is your range, try this

=IF(B5 = "", IF(B4 = "", ABS(1-(B3/B1)), ABS(1-(B4/B1))),
ABS(1-(B5/B1)))


--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=548624