software

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()lt;E4,D4,IF(TODAY()gt;=E4,H4,IF(TODAY()gt;E4amp; G4lt;=TODAY(),quot;PAID
OFFquot;,D4)))

Thanks,

Joseph--
jlab
------------------------------------------------------------------------
jlab's Profile: www.excelforum.com/member.php...oamp;userid=31060
View this thread: www.excelforum.com/showthread...hreadid=507345Maybe...

=if(and(today()gt;e4,today()gt;=g4),quot;paid offquot;,if(today()lt;e4,d4,h4))jlab wrote:
gt;
gt; Can someone help with this formula. It is supposed to do the following:
gt;
gt; Original amount --- paid -- 1st PMt date -- Paid -- 2nd pmt date
gt; -- balance
gt;
gt; 300 --- 150 --DATE -- 150 -- DATE -- Paid
gt; off
gt;
gt; =IF(TODAY()lt;E4,D4,IF(TODAY()gt;=E4,H4,IF(TODAY()gt;E4amp; G4lt;=TODAY(),quot;PAID
gt; OFFquot;,D4)))
gt;
gt; Thanks,
gt;
gt; Joseph
gt;
gt; --
gt; jlab
gt; ------------------------------------------------------------------------
gt; jlab's Profile: www.excelforum.com/member.php...oamp;userid=31060
gt; View this thread: www.excelforum.com/showthread...hreadid=507345

--

Dave Peterson