if statement

[jlab]

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

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

300 --- 150 --DATE -- 150 -- DATE -- Pai
off

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

Thanks,

Josep

 

[Dave Peterson]

Maybe...

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