If Funcation help

Hi,

Sorry i reposted threads because last threads i have wrongly mark as solved.

Can anyone please go through my request and provide me solution.

Sorry for inconvenience.

http://www.excelforum.com/excel-gene...condition.html
1) IF my total invoice (Column F) is $100 and i have received partial payment (Column G) $50 then as per days $50 comes under in between column I to L.

2) If i have received full payment (Column G) on 0 to 90 days then the payment amount comes under in between column I to L.

3) IF i have not received any payment then Total invoice (Column F) amount will comes under in between column I to L as per days outstanding.


I hope you understand my question.

Thanks