Can someone help with this formula. It is supposed to do the following:

Original amount --- paid -- 1st PMt date -- Paid -- 2nd pmt date
-- balance

300 --- 150 --DATE -- 150 -- DATE -- Paid
off

=IF(TODAY()<E4,D4,IF(TODAY()=E4,H4,IF(TODAY()E4& G4<=TODAY(),"PAID
OFF",D4)))

Thanks,

Joseph


--
jlab
------------------------------------------------------------------------
jlab's Profile: http://www.excelforum.com/member.php...o&userid=31060
View this thread: http://www.excelforum.com/showthread...hreadid=507345