Just select any of the cells in columns J or K to see the formulas.

(For row 2)

Column J = "=IF(D2-$A$1=10,25,0)"
Column K = "=(E2-C2)+I2+J2"


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=398296