F15 H15
I15 L8
=H14+I13 =IF(F15<G15,0,F15-G15) =IF(H15<=RL,RQ,0)
2(Cell name LT)


The Formula works perfectly but if L8 is changed it is not taken into
account. The Formula for F15 SHOULD be something like =H14+(I*15*-LT)
but any attempt at trying that has failed
*(*=ADDRESS(15-LT,9,4,1)+H14*)*


--
RPG_Gamer
------------------------------------------------------------------------
RPG_Gamer's Profile: http://www.excelforum.com/member.php...o&userid=28222
View this thread: http://www.excelforum.com/showthread...hreadid=477737