If Funcation help

[rchure]

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

[Richard Buttrey]

Does the attached help?

[rchure]

Hi Richard,

Thanks for reply...

Only one issue if i have received full payment "Column G" then its amount shows under column I to L which days is fulfil.

Ex- suppose i have received payment on 20 days then payment amount (Column G) shows under "column I" resp.

I hope you understand my query.

Thanks

[Richard Buttrey]

Sorry but I just don't see that.

Enter a full payment of 44211 in G7 and there is no analysis in columns I:L.

Can you clarify please.

[rchure]

Hi,

Actually we want to also see that after how many days we recevied full payment.

so in columns I:L we can find recevied payment amount days.

let me know if you have any other questions

Thanks

[Richard Buttrey]

Sorry but I still don't understand.

Are you saying that columns I:L contain numbers of days NOT currency values?

Please add several example lines and manually add the results you expect to see.

[rchure]

Sorry for confusing you.

I will disucss the sheet which you provided with my colleague and let you know if any changes required.

I will reply you on monday.

Thanks for your time any help..

[rchure]

Hi Rich,

I have confirm with my colleague no changes required for above formula.

Thanks for your help..