ExcelBanter - if statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if statement (https://www.excelbanter.com/excel-discussion-misc-queries/68789-if-statement.html)

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

Maybe...

=if(and(today()e4,today()=g4),"paid off",if(today()<e4,d4,h4))

jlab wrote:

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

--

Dave Peterson