# If Funcation help

1. ## 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

2. ## Re: If Funcation help

Does the attached help?

3. ## Re: If Funcation help

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

4. ## Re: If Funcation help

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.

5. ## Re: If Funcation help

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

6. ## Re: If Funcation help

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.

7. ## Re: If Funcation help

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..

8. ## Re: If Funcation help

Hi Rich,

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

Thanks for your help..

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1